mysql新建表出现错误

在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)