创建表时候出现了错误1064【42000】
mysql> use mydb;
Database changed
mysql> create table person(
-> id int not null auto_increment primary key comment'主键id',
-> name varchar(30)comment'姓名',
-> id_number varchar(18)unique comment '身份证号'
-> );
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_number varchar(18)unique comment '身份证号'
)' at line 3
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_number varchar(18)unique comment '身份证号'
)' at line 3
我把'单引号改正`反引号后依然报错
谁能帮忙看看怎么解决?