Tip: MySQL Table Naming Across Platforms

If your MySQL development and production environments are Mac OS X or Windows, queries containing all lowercase or uppercase table names will work fine. This is because these platforms are case-insensitive. However, if you deploy to a Unix system, queries referencing table names in the incorrect case will not work. Consequently, adopting a standard naming convention across platforms is the best policy. I decided to go with all lowercase with underscores between words (my_table_name).

For more information here’s a post by Craig Buckler on sitepoint.com.


Advertisements
Tip: MySQL Table Naming Across Platforms