Case-sensitive MySQL database table names, column names, and aliases

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.

Therefore, in order to make programs and databases run normally in different operating systems, the best way is to convert them to lower-case characters during design, but if the case is normalized during design, in Windows, you only need to modify the database configuration as follows:

Add a line to my. ini [mysqld] In the MySQL configuration file.

Lower_case_table_names = 1

Parameter description:

0: Case Sensitive

1: case insensitive