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
Post a Comment