mysql> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 0     |
+------------------------+-------+
1 row in set (0.00 sec)
 
mysql> 
 
mysql> use mydb;
Database changed
mysql> create table test(id int);
Query OK, 0 rows affected (0.07 sec)
 
mysql> create table TEST(id int);
Query OK, 0 rows affected (0.09 sec)
 
mysql> insert into test values(1);
Query OK, 1 row affected (0.03 sec)
 
mysql> insert into TEST value(2);
Query OK, 1 row affected (0.00 sec)
 
mysql> select * from test;
+------+
| id   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)
 
mysql> select * from TEST;
+------+
| id   |
+------+
|    2 |
+------+
1 row in set (0.00 sec)
 
mysql>

在设置文件my.cnf中配置lower_case_table_names=1后（1暗示不区分巨细写，0暗示区分巨细写），重启MySQL处过后，举办如下测试：

mysql> use mydb;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A
 
Database changed
mysql> select * from test;
+------+
| id   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)
 
mysql> select * from TEST;
+------+
| id   |
+------+
|    1 |
+------+
1 row in set (0.00 sec)
 
mysql>

苏州软件公司 的问题呈现" class="aligncenter size-full wp-image-29539" title="73542-20180815225124293-1996659401" src="/uploads/allimg/c180821/1534O5454BG0-192b.png" />

可以看到此时不管是test、TEST抑或Test，昆山软件开发，都是会见的test，此时不能会见”TEST”表了,系统变量lower_case_table_names是只读变量，昆山软件开发，也无法在当前会话修改，这种配置下，假如存在沟通的表名的话，利用mysqldump备份数据库时会碰着下面错误:

mysqldump: Got error: 1066: Not unique table/alias: ‘test’ when using LOCK TABLES

碰着这种环境就较量贫苦了，必需在设置文件my.cnf中配置变量lower_case_table_names=0，重启MySQL处事，所以提前筹划，利用统一的定名法则就很是重要，可以制止这样的问题呈现。别的系统变量lower_case_table_names有三个值：别离是0、1、2. 

1. 配置成0：表名按你写的SQL巨细写存储，大写就大写小写就小写，较量时巨细写敏感。 

2. 配置成1：表名转小写后存储到硬盘，较量时巨细写不敏感。  

3. 配置成2：表名按你写的SQL巨细写存储，大写就大写小写就小写，较量时统一转小写较量。 

关于数据库名巨细写敏感，会碰着下面问题：

1：ERROR 1010 (HY000): Error dropping database (can’t rmdir ‘./xxxx’, errno: 39)

1：ERROR 1010 (HY000): Error dropping database (can't rmdir './xxxx', errno: 39)
 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MyDB               |
| mydb               |
| mysql              |
| performance_schema |
| tmonitor           |
| xiangrun           |
+--------------------+
7 rows in set (0.01 sec)
mysql> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+
1 row in set (0.00 sec)
 
mysql> drop database mydb;
ERROR 1010 (HY000): Error dropping database (can't rmdir './mydb', errno: 39)
mysql>

办理要领：在设置文件my.cnf中配置变量lower_case_table_names=0，昆山软件开发，重启MySQL处事，然后就可以drop 掉数据库了。 

2： ERROR 1049 (42000): Unknown database ‘xxx’

mysql> show variables like 'lower_case_table_names';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| lower_case_table_names | 1     |
+------------------------+-------+
1 row in set (0.01 sec)
 
mysql> 
mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| MyDB               |
| mysql              |
| performance_schema |
| tmonitor           |
| xiangrun           |
+--------------------+
6 rows in set (0.01 sec)
 
mysql> use MyDB;
ERROR 1049 (42000): Unknown database 'mydb'
mysql>

参考资料：