Shulou(Shulou.com)06/01 Report--

Case sensitivity of mysql table names view mysql database case-sensitive parameters 1.1, show variables like 'lower%' '' parameter description lower_case_table_names: this parameter cannot be dynamically modified and must restart the database lower_case_table_names = 1. The table name is stored in lowercase on disk, but it is not case-sensitive when comparing. Lower_case_table_names = 0 the table name is stored in a given size and the comparison is case-sensitive.

It should be noted that when lower_case_table_names = 0, the data is inserted in uppercase, and the data in the stored mysql is case-sensitive by default. If lower_case_table_names is set to 1, the data cannot be found anyway.

You need to delete the inserted uppercase data when lower_case_table_names = 0, then modify the setting of lower_case_table_names = 1, and then insert the uppercase data before the query is successful.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.