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 '(1) comment '状态', number char(11) not null comment '手机号码', ' at line 5
检查SQL是正确的,为什么会报这个错误呢,有无高手帮忙看下,之前有遇到过,尝试将comment字段删除后即可成功运行,但是检查SQL语法貌似没什么问题,MySQL入门,辛苦大佬们看下
create table emp2(
id int null primary key comment '编号',
name varchar(10) unique not null comment '姓名',
gender char(1) comment '性别',
state char default (1) comment '状态',
number char(11) not null comment '手机号码',
achievement varchar(8) comment '成绩'
)comment '学生表';
具体截图如下: