Linux Mysql Case Sensitive

After mysql is installed in Linux, table names are case-sensitive by default, but column names are case-insensitive;

After logging on with the root account/Etc/my. cnfAdd lower_case_table_names = 1,

Restart the MYSQL service. The setting is successful: case insensitive to the table name;

Lower_case_table_names parameters:

Lower_case_table_names = 0

0: Case Sensitive, 1: case insensitive

In Linux, the database name, table name, column name, And alias are case-sensitive:

1. The database name and table name are case sensitive;

2. Table aliases are case sensitive;

3. The column name and column alias are case-insensitive in all cases;

4. Variable names are case sensitive;

MySQL is case insensitive in Windows.

Skip-name-resolve

This article is from the "lyq314" blog. For more information, contact the author!