mysql 5.7区分大小写_mysql-5.7.26 版本，表不区分区分大小写问题

目录

一、表不区分大小写

问题描述: 查询某张表没有记录，或者不存在，明明是有这个表的。

mysql> select * from cm_version;

+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+

| VERSION | GUID | LAST_UPDATE_INSTANT | TS | HOSTNAME | LAST_ACTIVE_TIMESTAMP |

+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+

| 5.13.3 | 1e440f97-6cea-403c-b712-f853b2a74752 | 1576748189778 | NULL | dataexa-cdh-test-01/192.168.1.228 | 1576830025460 |

+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+

mysql> select * from CM_VERSION;

ERROR 1146 (42S02): Table 'cm.