创建列表问题
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
 );