测试人社区

数据库创建表报错。。。

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='霍格沃兹测试学院用户表';

感谢