当前位置: 代码迷 >> Sql Server >> 创建列表有关问题
  详细解决方案

创建列表有关问题

热度:78   发布时间:2016-04-27 12:34:32.0
创建列表问题
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 );
  相关解决方案