Creating/dropping MySQL databases with integer names

Question

How to create/drop databases which have integers as their names, from the command line? Using GUI clients, I can create/drop them fine. However, 'create/drop database' does not seem to work because the names are integers.

Using GUI clients is fine with me, but curious to know: are there any workarounds to do this in command line?

Note: These databases are created from within an application which is since changed to not create databases with integer names!

Answer 1

use backticks '`' around the name of what you want to drop. The backtick key is the one that is generally up beside the 1 button on the keyboard.