mysql database name with char '?'

hi all u guys,

i don't know how but i've created a database in mysql with name web10?db1, how can i delete it? because i cant use drop rename because of char "?"

any ideas?

thks in advanced

 

try encasing the database name with -'- single quotes, and if that doesn't work try '`' the backtick (the one where the ~ is).

Code:

mysql> DROP DATABASE 'web10?db1';

OR  

mysql> DROP DATABASE `WEB10?DB`;

That should do it.

 

thks a lot it worked