当前位置:Gxlcms > 数据库问题 > MySql - syntax error: unexpted "user" (Single quoted text)

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

时间:2021-07-01 10:21:17 帮助过:31人阅读

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)

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

标签:ted   cte   unique   var   sql   creat   mysql   原因   mysq   

人气教程排行