Paste_Image.png
Paste_Image.png
<?php
try {
$pdo = new PDO('mysql:host=localhost;dbname=test', 'root', '');
//exec():执行一条sql语句并返回其受影响的记录的条数
//EXEC对于select没有作用
$sql = <<<EOF
CREATE TABLE IF NOT EXISTS user(
id INT UNSIGNED AUTO_INCREMENT KEY,
username VARCHAR(20) NOT NULL UNIQUE,
password VARCHAR(32) NOT NULL,
email VARCHAR(30) NOT NULL
);
EOF;
$res = $pdo->exec($sql);
var_dump($res);//int 0
} catch (PDOException $e) {
echo $e->getMessage();
}
?>
Paste_Image.png
