当我创build一个MySQL数据库时,我使用连字符(如aaron-kyle命名它。
当我检查数据库时,我看到:
mysql> show databases; +--------------------+ | Database | +--------------------+ | respect-joomla | +--------------------+
但我不能删除数据库。
我使用的具体命令是:
mysql> drop database respect-joomla;
错误:
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 '-joomla' at line 1
我也试过:
mysql> DROP DATABASE 'respect-joomla';
我犯了同样的错误:
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 ''respect-joomla'' at line 1
有没有特别的方法来写 – 在MySQL中(就像命令行中的空格是\\)?
尝试像这样:
DROP DATABASE `aaron-kyle`;