mysql反引号作用

作用

区分MySQL的保留字符与普通字符
例如创建一个select的数据库时，select是MySQL的保留字符，不用反引号会报错。像这种要以MySQL保留字做表名，字段，数据库名字的必须加上反引号

栗子

不加任何引号报错

mysql> create database select;
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 'select' at line 1

单引号报错

mysql> create database 'select';
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 ''select'' at line 1

反引号正常

mysql> create database `select`;
Query OK, 1 row affected (0.00 sec)