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