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

3 Comments

  1. 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, […]

  2. Emad

    Hi There

    Thanks for the help, but I am a novice to MySQL can cannot find my.cnf file

  3. 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

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>