创建列表问题
mysql> create table db_user(uuid int(11) IDENTITY(1,1) NOT NUll,
-> password varchar(8) NOT NULL,
-> displayname varchar(256) NOT NULL,
-> permission varchar(256) NOT NULL,
-> logtime datetime NOT 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 'IDENTITY(1,1) NOT NUll,
password varchar(8) NOT NULL,
------解决方案--------------------
SQL code
create table db_user
( uuid int IDENTITY(1,1) NOT NUll,
password varchar(8) NOT NULL,
displayname varchar(256) NOT NULL,
permission varchar(256) NOT NULL,
logtime datetime NOT NULL
);