MY SQL简单错误请指教
mysql>createtablecheese->(idintunsignednotnullauto-toincerment,namevarchar(64)notnull...
mysql> create table cheese
-> (id int unsigned not null auto-toincerment,name varchar(64) not null,
-> country char(2) not null, primary key(id));
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 'auto-
toincerment,name varchar(64) not null,
country char(2) not null, primary ke' at line 2
mysql> 展开
-> (id int unsigned not null auto-toincerment,name varchar(64) not null,
-> country char(2) not null, primary key(id));
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 'auto-
toincerment,name varchar(64) not null,
country char(2) not null, primary ke' at line 2
mysql> 展开
展开全部
auto-toincerment ？
因该是auto_increment ?
因该是auto_increment ?
本回答由提问者推荐
已赞过
已踩过<
评论
收起
你对这个回答的评价是？
推荐律师服务：
若未解决您的问题，请您详细描述您的问题，通过百度律临进行免费专业咨询
