Not able to drop database due to '-' character 1

[spookie]

Hi,

I have a database name having a '-' character in it. I am using mysql V 5.1 on Windows and I am unable to drop the database. Any suggestions on how to drop DB..



--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[ingresman]

look up back-ticks and enclose the nane in those. They are differecnt from single quotes but i can't recall the key stroke to get it. Google or the manula or here will help.

 

[spookie]

Hi ingresman ,

It worked.

drop databse `database-name`;
[\quote]

I am out of touch with this stuff and could not recollect. Thanks for pointing this out.

--------------------------------------------------------------------------
I never set a goal because u never know whats going to happen tommorow.

 

[r937]

ingresman, the backtick is located along with the tilde (~) in the top left corner of the keyboard



r937.com | rudy.ca
Buy my new book Simply SQL from Amazon

 

[ingresman]

double whammy !
have a good day guys