create table 'user'( 'id' int(11) not null auto_increment, 'username' varchar(200) default null, 'p

SQL 查询:

CREATE TABLE 'user'(

'id'int( 11 ) NOT NULL AUTO_INCREMENT ,
'username'varchar( 200 ) default NULL ,
'password'varchar( 200 ) default NULL ,
'sex'int( 4 ) default NULL ,
'email'varchar( 200 ) default NULL ,
'role'int( 4 ) default NULL ,
PRIMARY KEY ( 'id' ) ) ENGINE = Innodb default CHARSET = latinl

MySQL 返回：

#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 ''user'(
'id' int(11) not null auto_increment,
'username'' at line 1
什么问题 麻烦解决一下！~

---

CREATE TABLE `user` (
`id` int( 11 ) NOT NULL AUTO_INCREMENT ,
`username` varchar( 200 ) default NULL ,
`password` varchar( 200 ) default NULL ,
`sex` int( 4 ) default NULL ,
`email` varchar( 200 ) default NULL ,
`role` int( 4 ) default NULL ,
PRIMARY KEY ( `id` )
) ENGINE = Innodb default CHARSET = gb2312

把 单引号换成如枝 ` latinl 不识别渣袜敏 换成好搏gb2312

---