Skip to main content

Posts

Showing posts from May, 2019

Configure MySQL to handle camel case (or case sensitive) table names and column names

The default settings provided of MySQL enforce a strict lowercase conversion for all the table and database names. To allow camel case in mysql we need to made following changes in mysql configuration file.   lower_case_table_names It can easily be added to the MySQL my.ini file, usually found in the following folder: C:\xampp\mysql\bin The easiest way to take care of this is to add the following to your my.ini file under the [mysqld] section. [mysqld] ... lower_case_table_names = 2 And Restart Xampp.