-   Linux - General (
-   -   mysql syntax question (

pk21 05-18-2004 04:13 AM

mysql syntax question
Hi all,

Ive got this database "test.12", but i can't drop it because it contains a "."
Anyone knows how to do this?

ERROR 1064: You have an error in your SQL syntax near '.1' at line 1

trickykid 05-18-2004 06:30 AM

You've tried with single quotes as well?

mysql > DROP 'test.12'

If that doesn't work, you can always manually remove the database from /var/lib/mysql but that's not recommended.

All times are GMT -5. The time now is 10:19 PM.