MySQL Error with TIMESTAMP

Question

$sql = "CREATE TABLE heros (
ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
battletag varchar(64) ,
name varchar(32),
id int,
level int,
hardcore bool,
gender bool,
dead bool,
class varchar(32),
updated TIMESTAMP
";

出现错误:

创建表出错:你的SQL语法有错误;检查对应于MySQL服务器版本的手册near " at line 11

使用的语法

Answer 1

您忘记了您的结束字符)。清洗:

CREATE TABLE heros (
    ID int NOT NULL AUTO_INCREMENT PRIMARY KEY,
    battletag varchar(64) ,
    name varchar(32),
    id int,
    level int,
    hardcore bool,
    gender bool,
    dead bool,
    class varchar(32),
    updated TIMESTAMP
)