One, Linux MySQL case details:
1, the database name is strictly case-sensitive
2. Table names are strictly case-sensitive
3. Table aliases are strictly case-sensitive
4. Variable names are strictly case-sensitive
5, column names in all cases are ignored case
6. The alias of the column ignores the case in all cases
Second, set MySQL table name is not case-sensitive
1. Switch to the root user
$ su-root
2, modify the/ETC/MY.COF configuration file,
# sed-i '/mysqld/a\lower_case_table_names=1 '/etc/my.cnf
Lower_case_table_names parameter Details:
? 0: Case Sensitive
? 1: Case insensitive
3. Restart MySQL
# Service Mysqld Restart
4. View Mqsql Parameters
# mysql-uroot-p
> Show variables like "%case%";
+------------------------+-------+
| variable_name | Value |
+------------------------+-------+
| Lower_case_file_system | OFF |
| Lower_case_table_names | 1 |
+------------------------+-------+
2 rows in Set (0.00 sec) http://blog.csdn.net/qq_29246225/article/details/52293549
Linux under the case of MySQL is set to distinguish between