database create - How to get table names in capital letters in MySQL 5.6 -


i want create table name starts capital letter in mysql version 5.6 . in version 5.0 can use lower_case_table_names=0 in my.ini file , restart mysql works.

but in 5.6 version not able work.

you can set lower_case_table_names system variable in my.ini. add parameter @ bottom of config file:

lower_case_table_names=2 

there 3 options available, 0, 1, , 2. read on options do: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html

note: there big difference between how identifier names presented user through phpmyadmin, , how identifier matching done within sql statement.


Comments