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
Looking for PHP, Laminas or Mezzio Support?
As part of the Laminas Commercial Vendor Program, Apidemia offers expert technical support and services for:
3 Comments-
-
-
camelCase Table Names in MySQL on Windows » DotKernel
[…] more: camelCase Table Names in MySQL on Windows » DotKernel Posted in Uncategorized | Tags: kernel-leave, table, table-names, wamp, wamp-or-xaamp, […]
Emad
Hi There
Thanks for the help, but I am a novice to MySQL can cannot find my.cnf file
Julian
If you don’t have the my.cnf file, you must have a my.ini file
Add that under [mysqld] section.
INSTALLDIR\my.ini, INSTALLDIR\my.cnf
http://dev.mysql.com/doc/refman/5.1/en/option-files.html