MySQL Case cancellation sensitive settings

MySQL Case cancellation sensitive settings

#mysqld--set-lower_case_table_names=1;

Or add a configuration entry in the MySQL server configuration file:

Vi/etc/my.cnf

Lower_case_table_names=1

The value of the variable is defined in detail as follows:

Value	meaning
0	Table and database names is stored on disk using the lettercase specified in theCREATE TABLEorCREATE DATABASEstatement. Name comparisons is case sensitive. You should the not set the this variable to 0 if is running MySQL on a system it has case-insensitive file names (such as W indows or Mac OS X). If you are variable to 0 with--lower-case-table-names=0On a case-insensitive the file system and access MyISAM Tablenames using different lettercases, index corruption may resu Lt.
1	table names is stored in lowercase on disk and name comparisons is not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.
2	Table and database names is stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement, but MySQL converts them-lowercase on lookup. Name comparisons is not case sensitive. This works with file systems that is not a case sensitive! InnoDB table names is stored in lowercase, as Forlower_case_table_names=1.

This article is from the "Hao (pcdog) blog" blog, make sure to keep this source http://433266.blog.51cto.com/423266/1869824

MySQL case cancellation sensitive settings