I have a client database in my db dev server environment I need to create, but the client name contains a dash "-". This blows up upon attempting to do
create database my-site;
How then do I create this database, simple as that?
Thanx Phil
from http://www.mysql.com/doc/en/Legal_names.html :
An identifier may be quoted or unquoted. If an identifier is a reserved word or contains special characters, you must quote it whenever you refer to it. For a list of reserved words, see section 10.6 Treatment of Reserved Words in MySQL. Special characters are those outside the set of alphanumeric characters from the current character set, _', and$'.
_', and
Try create database "my-site";
when you say 'blows up', what is the error?
