MySQL Tips:操作中某些名称含有特殊符号

博客文章除注明转载外，均为原创。转载请注明出处。
本文链接地址：http://blog.chinaunix.net/uid-31396856-id-5767191.html

mysql> show tables like 'crmcs_information_dk_1%';
+----------------------------------------+
| Tables_in_crmdb ('crmcs_information_dk_1%) |
+----------------------------------------+
| 'crmcs_information_dk_12-17                 |
+----------------------------------------+
1 row in set (0.00 sec)

mysql> drop table crmcs_information_dk_12-17;
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 '-17' at line 1
报错信息：1064，含有"-"

处理方法：使用`xxxx`将相关名称引用（！左边键）
mysql> drop table `crmcs_information_dk_12-17`;
Query OK, 0 rows affected (0.02 sec)

---The end