建表的时候报的错误，我的数据库版本是5.5.28

来源：2-2 _数据库设计

爱Zpony

2018-10-16

[SQL]
CREATE TABLE t_user (
id INT(11) NOT NULL IDENTITY PRIMARY KEY ,
name VARCHAR(32) NOT NULL UNIQUE ,
password VARCHAR(32) NOT NULL ,
email VARCHAR(32) NOT NULL UNIQUE ,
phone_number VARCHAR(15) NOT NULL UNIQUE ,
status INT(2) NOT NULL ,
avatar VARCHAR(255),
create_time DATETIME NOT NULL DEFAULT NOW(),
last_login_time DATETIME NOT NULL ,
last_update_time DATETIME NOT NULL DEFAULT NOW()
);
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘IDENTITY PRIMARY KEY ,
name VARCHAR(32) NOT NULL UNIQUE ,
password VAR’ at line 2

写回答

2回答

noblenooble

2019-03-12

若使用IDENTITY 不能为空

CREATE TABLE t_user (
id INT(11) NOT NULL IDENTITY(1,1) PRIMARY KEY , #id 默认值为1 每次自增1
name VARCHAR(32) NOT NULL UNIQUE ,
password VARCHAR(32) NOT NULL ,
email VARCHAR(32) NOT NULL UNIQUE ,
phone_number VARCHAR(15) NOT NULL UNIQUE ,
status INT(2) NOT NULL ,
avatar VARCHAR(255),
create_time DATETIME NOT NULL DEFAULT NOW(),
last_login_time DATETIME NOT NULL ,
last_update_time DATETIME NOT NULL DEFAULT NOW()
);