日期:2014-05-18  浏览次数:20532 次

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