How to make mysql case-insensitive: 1. Enter the installation directory of mysql, find and open the configuration file "my.ini"; 2. Add the "lower_case_table_names=1" statement to the last line of the configuration file , set the case-sensitive parameter "lower_case_table_names" to make mysql insensitive to case; 3. Restart the mysql service.
The operating environment of this tutorial: windows7 system, mysql8 version, Dell G3 computer.
How to make mysql case-insensitive
Mysql case-sensitive configuration is related to two parameters - lower_case_file_system and lower_case_table_names
lower_case_file_system: Indicates whether the current system file is case-sensitive (ON means insensitive, OFF means sensitive), a read-only parameter that cannot be modified.
lower_case_table_names: Indicates whether the table name is case-sensitive and can be modified.
The lower_case_file_system parameter cannot be modified, so the lower_case_table_names parameter can only be used to make mysql case-insensitive.
Steps:
1. Enter the mysql installation directory, find and open the configuration file my.ini
2. Add the following sentence to the last line of the configuration file
lower_case_table_names=1
lower_case_file_system indicates whether the file system where the data directory is located is sensitive to the case of the file name
0: Case-sensitive
1: Case-insensitive
3, Just restart the mysql service.
Note:
To set the default lower_case_tables_name from 0 to 1, you need to convert the existing library table name to lowercase first:
1) For the case where only uppercase letters exist in the table name:
①, when lower_case_tables_name=0, execute rename table to lowercase.
②. Set lower_case_tables_name=1 and it will take effect after restarting.
2) For the case where uppercase letters exist in the library name:
① When lower_case_tables_name=0, use mysqldump to export and delete the old database.
②. Set lower_case_tables_name=1 and it will take effect after restarting.
③. Import data into the instance. At this time, the library name containing uppercase letters has been converted to lowercase.
[Related recommendations:mysql video tutorial]
The above is the detailed content of How to make mysql case insensitive. For more information, please follow other related articles on the PHP Chinese website!