MySQL is case insensitive (Linux and Windows)

 MySQL in Linux Database Name, table name, column name, alias case-sensitive rules:
1. The database name and table name are case sensitive.

2. The table alias is case sensitive.

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

4. Variable names are case sensitive.

Note:

A. After MySQL is installed in Linux, the default value is case-sensitive for table names, but not for column names.

B. How to change the case sensitivity rules of table names: Log On with the root account and log on to/etc/My. CNF or/etc/MySQL/My. add lower_case_table_names = 1 after [mysqld] In CNF and restart the MySQL service. If the setting is successful, the table name is case-insensitive.

NOTE: If my. CNF cannot be found in/etc or/etc/MySQL, You need to copy it from other places, because when installing MySQL using rpm, You need to manually copy my. CNF. Specific operations:

Find the *. CNF file under/usr/share/MySQL/, copy one of the files to/etc/and change it to my. CNF. The command is as follows:

[Root @ test1 MySQL] # cp/usr/share/MySQL/my-medium.cnf/etc/My. CNF

Where:

My-small.cnf is designed for small databases. This model should not be used in databases that contain common projects.
My-medium.cnf is designed for medium-sized databases.

The my-large.cnf is designed for a computer dedicated to a SQL database.

My-huge.cnf is designed for databases in enterprises.

[Windows]

MySQL databases, table names, column names, and aliases in windows are case-insensitive..

If you want to use case-sensitive data, use the mysqld section in my. ini.

Add lower_case_table_names = 0

  Note: even if this setting is changed in windows, the query is case insensitive. Only the case sensitivity is different during import and export.