LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - General (https://www.linuxquestions.org/questions/linux-general-1/)
-   -   mysql syntax question (https://www.linuxquestions.org/questions/linux-general-1/mysql-syntax-question-182785/)

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 05:38 PM.