ERROR 1064 (42000)
描述:
mysql> CREATE TABLE 'person' (
-> 'user_id' int(11) NOT NULL AUTO_INCREMENT,
-> 'user_name' varchar(260) DEFAULT NULL,
-> 'sex' varchar(260) DEFAULT NULL,
-> 'email' varchar(260) DEFAULT NULL,
-> PRIMARY KEY ('user_id')
-> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
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 ''person' (
'user_id' int(11) NOT NULL AUTO_INCREMENT,
'user_name' varchar(260) D' at line 1
解决:
-
在MySQL中,为了区分MySQL的关键字与普通字符,MySQL引入了一个反引号。
-
mysql> create table `person` ( -> `user_id` int(11) NOT NULL AUTO_INCREMENT, -> `user_name` varchar(260) DEFAULT NULL, -> `sex` varchar(260) DEFAULT NULL, -> `email` varchar(260) DEFAULT NULL, -> PRIMARY KEY (`user_id`) -> ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; Query OK, 0 rows affected, 2 warnings (0.02 sec)