mysql lower_case_table_names 区分表名大小写设置

Command-Line Format --lower-case-table-names[=#]
System Variable Name lower_case_table_names
Variable Scope Global
Dynamic Variable No
Permitted Values Type integer
Default 0
Min Value 0
Max Value 2


设置成0,存储磁盘时的值为给定的值,对比时区分大小写。
设置成1,存储磁盘表名被转为小写,对比时不区分大小写。
设置成2,存储磁盘时的值为给定的值,但对比时用小写来比较

On Windows the default value is 1
On OS X, the default value is 2.

You should not set lower_case_table_names to 0 if you are running MySQL on a system where the data directory resides on a case-insensitive file system (such as on Windows or OS X).

原文地址:https://www.cnblogs.com/zejin2008/p/7682075.html