MySql - syntax error: unexpted "user" (Single quoted text)

create table user(
id int(10) not null,
username varchar(20) not null,
password varchar(20) not null,
primary key (id),
unique key username);

错误原因:  去掉 单引号, 改为如下

mysql> create table user(
    -> id int(10) not null,
    -> username varchar(20) not null unique,
    -> password varchar(20) not null,
    -> primary  key (id),
    -> unique key ulist (username)
    -> );
Query OK, 0 rows affected, 1 warning (0.32 sec)
文章来自:http://www.cnblogs.com/FightZ/p/6754076.html
© 2021 jiaocheng.bubufx.com  联系我们
ICP备案:鲁ICP备09046678号-3