camelCase Table Names in MySQL on Windows

If you are using a WAMP stack, like WAMP or XAMPP, and try to create a table in camelCase ( example: adminLogin) you will notice that camelCase is not working, table name will be lowercase: adminlogin.
In order to fix this, you need to add to your my.cnf file the line:

lower_case_table_names=2

and restart mysql.

More on that here: http://dev.mysql.com/doc/refman/4.1/en/server-system-variables.html#sysvar_lower_case_table_names

This entry was posted in DotKernel. Bookmark the permalink.