【MySQL】SQL语法错误

Question

是创建表的函数，不知怎么一直报错，运行环境是MySQL8.0.11

mysql>  create table(id int(11)primary key,name varchar(32),password varchar(32),status int(1))default charset=utf8;
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 '(id int(11)primary key,name varchar(32),password varchar(32),status int(1))defau' at line 1

Answer 1

目测是id字段中，主键定义和类型之间少个空格.....

欢迎关注，《一行代码把服务干挂了，竟然是Docker误把库删了......》, 一起来围观吧 https://blog.csdn.net/qq_34417408/article/details/117388594?utm_source=app&app_version=4.8.0&code=app_1562916241&uLinkId=usr1mkqgl919blen