What characters can I use to name my tables and fields, and what is the character limit?
The maximum length of database, table, or field names is 64 characters. Any character that you can use in a directory or filename, you can use in database and table names?except (/) and (.). These limitations are in place because MySQL creates directories and files in your file system, which correspond to database and table names. There are no character limitations (besides length) in field names.