Scenario: The company recently turned the database from Oracle to MySQL, because the table name is not case-sensitive in Oracle , so there is no table found in Mysql problem, the Internet query, found under Linux Mysql table names are case-sensitive, but parameters can make them case insensitive. Here's how:
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)
Third, other
In Windows, MySQL is always case-insensitive.
MySQL table names are not case-sensitive under Linux
