MySQL: Can't give tables a name in Upper Camel Case (Pascal Case)

mysql naming-conventions camelcasing pascalcasing
Pascal Klein picture Pascal Klein · Dec 5, 2010 · Viewed 14.1k times · Source

I read that it is best practise to have table names in Pascal Case (ThisIsMyTableName). Therefor I would like to change my tables in MySQL. But neither phpmyadmin, nore SQL Manager 2005 for MySQL will let me. The names stay to appear in lowercase, as if I didn't to a change at all.

Any suggestions to solve this problem?

Answer

swisscheese picture swisscheese · Apr 6, 2011

The easiest way to take care of this is to add the following to your .ini file

lower_case_table_names=2

2 is the significance here for Windows. You can read more about it here Identifier Case Sensitivity

Related questions

Is there a naming convention for MySQL?

Here's how I do it: Table names are lower case, uses underscores to separate words, and are singular (e.g. foo, foo_bar, etc. I generally (not always) have a auto increment PK. I use the following convention: tablename_id (…

Read More
What is a proper naming convention for MySQL FKs?

Being that they must be unique, what should I name FK's in a MySQL DB?

Read More
How do I import an SQL file using the command line in MySQL?

I have a .sql file with an export from phpMyAdmin. I want to import it into a different server using the command line. I have a Windows Server 2008 R2 installation. I placed the .sql file on the C drive, and …

Read More