Cannot drop table

mysql> drop database rcgl-petitions;
ERROR 1064: You have an error in your SQL syntax near '-petitions' at
line 1
mysql> drop database rcgl\-petitions;
ERROR:
Unknown command '\-'.
ERROR 1064: You have an error in your SQL syntax near '\-petitions' at
line 1
mysql> drop database 'rcgl\-petitions';
ERROR 1064: You have an error in your SQL syntax near
''rcgl\-petitions'' at line 1
mysql> drop database 'rcgl-petitions';
ERROR 1064: You have an error in your SQL syntax near ''rcgl-petitions''
at line 1

I also tried dropping it in phpMyAdmin 2.8.0.3 It says "Database
`rcgl-petitions` has been dropped. (Query took 0.0002 sec)" but the db
is still there.

MySQL is 3.23.58-9 under Fedora Core 2.

--
* John Oliver http://www.john-oliver.net/ *
* Reform California gun laws - http://www.reformcagunlaws.com/ *
* http://www.gunownersca.com - http://www.crpa.org/ *
* San Diego shooters come to http://shooting.forsandiego.com/ *

John Oliver wrote:
> mysql> drop database rcgl-petitions;
> ERROR 1064: You have an error in your SQL syntax near '-petitions' at
> line 1
> mysql> drop database rcgl\-petitions;
> ERROR:
> Unknown command '\-'.
> ERROR 1064: You have an error in your SQL syntax near '\-petitions' at
> line 1
> mysql> drop database 'rcgl\-petitions';
> ERROR 1064: You have an error in your SQL syntax near
> ''rcgl\-petitions'' at line 1
> mysql> drop database 'rcgl-petitions';
> ERROR 1064: You have an error in your SQL syntax near ''rcgl-petitions''
> at line 1
>
> I also tried dropping it in phpMyAdmin 2.8.0.3 It says "Database
> `rcgl-petitions` has been dropped. (Query took 0.0002 sec)" but the db
> is still there.
>
> MySQL is 3.23.58-9 under Fedora Core 2.
>

http://dev.mysql.com/doc/refman/5.1/en/legal-names.html

DROP DATABASE `rcgl-petitions`;

Where ` is a backtick.
--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================