Detailed explanation of MySQL table name case-insensitive configuration method

By default, MySQL in Linux distinguishes between upper and lower case table names. Whether MySQL is case sensitive is determined by the parameter lower_case_table_names, where:

1) lower_case_table_names = 0

Case-sensitive (not case sensitive), this is the default setting. After this setting, it does not matter whether the table names created in MySQL contain uppercase letters or not, they can all be read and referenced normally.

2) lower_case_table_names = 1

Case-insensitive (i.e. case sensitive). After this setting, the table names are saved in lowercase on the hard disk, and MySQL converts all table names to lowercase for storage and search. This behavior also applies to database names and table aliases .

That is to say, after MySQL is set to be case-insensitive, when creating a database or table, no matter if uppercase letters are used when creating it, it will be forced to be saved in lowercase after the creation is successful!

The case rules for MySQL database names, table names, column names, and aliases under Linux are as follows:

1) Database names and table names are strictly case-sensitive;

2) Table aliases are strictly case-sensitive;

3) Column names and column aliases are case-insensitive in all cases;

4) Variable names are also strictly case-sensitive;

5) MySQL is not case-sensitive under Windows, but is case-sensitive by default under Linux.

6) If you want to distinguish between uppercase and lowercase letters when querying, you need to set the BINARY attribute for the field value. There are several ways to set it:
a) Setting at creation time:
CREATE TABLE T(A VARCHAR(10) BINARY);
b) Use alter to modify

Therefore, in order to ensure that programs and databases can run normally in different operating systems, the best way is to convert them to lowercase when designing tables! !

Modify mysql to be case-insensitive:

mysqladmin -uroot -p shutdown //Shut down the database in safe mode

Modify my.cnf //Add the following line of settings
.....
[mysqld]
lower_case_table_names=1
.....

Start mysql

The above detailed explanation of the configuration method of ignoring case in MySQL table names is all the content that the editor shares with you. I hope it can give you a reference. I also hope that you will support 123WORDPRESS.COM.