create table ‘hogwarts_user’ (
‘id’ int(11) unsigned not null auto_increment comment ‘ID’,
‘name’ varchar(100) default null comment '名称’,
primary key (‘id’) using btree
) engine=innodb auto_increment=8 default charset=utf8 row_format=dynamic comment=‘霍格沃兹测试学院用户表’;
1064 - 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 ‘‘hogwarts_user’ (
‘id’ int(11) unsigned not null auto_increment comment ‘IDâ’ at line 1
可以这样写:
create table hogwarts_user(
id int(11) primary key auto_increment comment 'ID',
name varchar(100) default null comment '名称'
) engine=innodb auto_increment=8 default charset=utf8 row_format=dynamic comment='霍格沃兹测试学院用户表';
感谢