mysql 1064错误

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 '123456' at line 1

这种错误往往是由于自己不小心造成的。
现在就把整个错误过程演绎一遍吧！！！

1. 显示所有数据库

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| 123456             |
| 7weiblog           |
| mysql              |
| performance_schema |
+--------------------+
5 rows in set (0.00 sec)

2. 看到123456这个数据库，想删除。

 mysql> drop database 123456;
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 '123456' at line 1
mysql> drop database '123456';
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 ''123456'' at line 1
mysql> drop database "123456";
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 '"123456"' at line 1

都出现错误
3. 改变数据库上面的引号，使其变成反向的123456

mysql> drop database `123456`;
Query OK, 0 rows affected (0.04 sec)

发现错误已经排除了