mysql新建表出现错误

在centos6.5里面使用mysql创建表的时候&＃xff0c;遇到这个问题
“&＃96;&＃96;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 (&＃39;id&＃39; int(4), &＃39;name&＃39; 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 &＃39;&＃39;id&＃39; int(4), &＃39;name&＃39; char(40))&＃39; at line 1


改了几次还是出现这个问题&＃xff0c;后面才发现id&＃xff0c;name的那个单引号不是普通的单引号&＃xff0c;而是esc键下面那个键&＃xff08;~&＃xff09;上面的反引号&＃xff0c;由此记录一下&＃xff0c;以防下次再遇到这样的问题。 将单引号换成了””之后顺利建表成功&＃xff1b;

mysql> create table t1 (&＃96;id&＃96; int(4), &＃96;name&＃96; char(40), &＃96;age&＃96; int(4));
Query OK, 0 rows affected (0.02 sec)