mysql database name with char '?'

Discussion in 'Server Operation' started by lyndros, Sep 3, 2006.

  1. lyndros

    lyndros New Member

    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
  2. drks

    drks New Member HowtoForge Supporter

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

    mysql> DROP DATABASE 'web10?db1';
    mysql> DROP DATABASE `WEB10?DB`;
    That should do it.
  3. lyndros

    lyndros New Member

    thks a lot it worked :p

Share This Page