表:CREATETABLEuser(idINTEGERNOTNULLAUTO_INCREMENT,usernameVARCHAR(63)NOTNULLUNIQUE,passwordVARCHAR(63)NOTNULL,last_login_timeDATETIMENOTNULL,last_login_ipCHARNOTNULL,user...
表:
CREATE TABLE user
(
id INTEGER NOT NULL AUTO_INCREMENT,
username VARCHAR(63) NOT NULL UNIQUE ,
password VARCHAR(63) NOT NULL,
last_login_time DATETIME NOT NULL,
last_login_ip CHAR NOT NULL,
user_level TINYINT(3) DEFAULT 0,
nickname VARCHAR(63) NOT NULL,
avatar CHAR NOT NULL,
status TINYINT(3) NOT NULL DEFAULT 0,
created_time DATETIME NOT NULL,
update_time DATETIME NOT NULL,
`delete` TINYINT(1) NOT NULL DEFAULT 0,
email VARCHAR(31) UNIQUE ,
token VARCHAR(127) UNIQUE ,
PRIMARY KEY (id)
);
Preparing: insert into user (id, username, password, last_login_time, last_login_ip, user_level, nickname, avatar, status, created_time, update_time, delete, email, token) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters: null, wa(String), 1(String), 2020-04-06 05:00:57.029(Timestamp), 127.0.0.1(String), 1(Byte), test(String), /(String), 0(Byte), 2020-04-06 05:00:57.029(Timestamp), 2020-04-06 05:00:57.029(Timestamp), 0(Byte), null, null
insert into user (id, username, password, last_login_time, last_login_ip, user_level, nickname, avatar, status, created_time, update_time, delete, email, token) values (null, 'wa', '1', '2020-04-06 05:00:57.029', '127.0.0.1', 1, 'test', '/', 0, '2020-04-06 05:00:57.029', '2020-04-06 05:00:57.029', 0, null, null)
报错:
ERROR 1064 (42000): 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 'delete, email, token) values (null, 'wa', '1', '2020-04-06 05:00:57.029'' at line 1
展开