How to create database with a dash in the name?

ppowell

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

Trent_Hatred

Here's something I read in the MySQL documentation.

"It is NOT possible (or at least should not be possible) to create a database containing a hyphen/dash.

In MySQL it seems to be possible and this error gets obvious when selecting from this database.

So just don't do it."

If possible, create it with an underscore (_) rather than a dash. From what I understand, dashes can end up causing nothing but grief later on.

Cheers,
B

ppowell

I would've used an underscore where it not for the client name having a dash in it and their wanting the database name to reflect each client associated with it.

sigh

Phil

Trent_Hatred

Ahh, that's a tough one PPowell.

Unfortunately, I just read a bit more documentation on this. Seems the dash is a reserved character in MySQL.

🙁

ppowell

Well it's a moot point. Turns out I don't even have the permissions to even create a database on my own dev environment! 🙁 😡

Phil