Is it possible to have dashes in a MySQL table?

Question

I have a hyphen in both the database name (site-usersite) and the table name (site-users) and am running into errors after looking through my code a lot. Is the hyphen messing it up?

Answer 1

Its not a great idea to use hyphens as table names because in SQL, hyphens are usually used as a remark and to comment out an SQL command.

I would just use the _ underscore since its the conventional spacing character for table names.