Scenario: The company recently in the database from Oracle to MySQL, because the table name is not case-sensitive in Oracle, so there is no table in MySQL problem, the Internet query, found in Linux MySQL table name is case-sensitive, However, there are parameters that make it case insensitive.
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, add parameters to make them case insensitive
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)
Third, other
In Windows, MySQL is always case-insensitive.
Linux/centos setting MySQL table name is case insensitive
