在centos6.5里面使用mysql创建表的时候,遇到这个问题
“``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’ int(4), ‘name’ char(40))’ at line 1”
mysql> create table t1 ('id' int(4), 'name' char(40));
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' int(4), 'name' char(40))' at line 1
改了几次还是出现这个问题,后面才发现id,name的那个单引号不是普通的单引号,而是esc键下面那个键(~)上面的反引号,由此记录一下,以防下次再遇到这样的问题。 将单引号换成了”
”之后顺利建表成功;
mysql> create table t1 (`id` int(4), `name` char(40), `age` int(4));
Query OK, 0 rows affected (0.02 sec)