Hyphen in database name

[pen81]

I get a syntax error when attempting to drop one of my databases. Its name contains a hyphen, which seems to be the problem, although the USE statement accepts the database name.

I am using version 3.23.43.

 

[guelphdad]

have you tried the backtick ` around the database name like this:

drop database `databasename`

 

[pen81]

I have just tried single and double quotes around the database name and I still get the syntax error.

I have found that deleting the files and directory from the data directory seems to work

 

[towerbase]

Single or Double quotes will probably not work. The backtick that quelphdad suggested is not the same as a single or double quote.

I'm using MySQL v5.0.13 and the MySQL Query Browser would not allow me to do

create database scrap-it

But it would allow me to

create database `scrap-it`

The same applied to dropping the database. So I suggest you try quelphdad's suggestion and use back ticks.

Andrew
Hampshire, UK

 

[pen81]

Back ticks worked, thanks very much for your help!