There is nothing wrong with lower_case_table_names=0

Recently, I have found that I have encountered a lot of things. I know clearly that I am wrong, but I still ask others to make changes. It is so strange.

It's good to write a small document quietly.

Mysql > show tables | t_txn_net | # # this table exists | t_txn_pmc_breaker | | t_txn_regedit | | t_workday_pgm | | t_workday_set | +-- -+ 142 rows in set (0.00 sec) mysql > select * from t_txn_neT # ERROR 1146 (42S02) does not exist in the query table: Table 'upp.t_txn_neT' doesn't existmysql > mysql > mysql > show variables like' lower_case_table_names' # # case sensitive There is nothing wrong with this. +-+-+ | Variable_name | Value | +-+-+ | lower_case_table_names | 0 | +-+- -+ 1 row in set (0.00 sec) DBA there is always a way. The operation steps are as follows: 1. Close the library shutdown;2, modify the parameter vi my.cnflower_case_table_names = 1 # # case-insensitive 3, open the library mysqld_safe-- defaults-file=/etc/my.cnf & 4, query again, OKmysql > select * from tactitxnroomneTempty set (0.00 sec) 5, view lowercase table name value=1mysql > show variables like 'lower%' +-+-+ | Variable_name | Value | +-+-+ | lower_case_file_system | OFF | | lower_case_table_names | 1 | +- -+-+ 2 rows in set (0.01sec)