在mysql中的特殊字符?

当我创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`;