mysql表名大小写敏感_MySQL表名大小写敏感变量配置

在windows上lower_case_table_names变量的缺省值为1; 在linux上为0; 在mac os上为2;

详细定义如下:

0敏感 1不敏感 2macos?

0 Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or Mac OS X). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result.

1 Table names are stored in lowercase on disk and name comparisons are not case sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.

2 Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement, but MySQL converts them to lowercase on lookup. Name comparisons are not case sensitive. This works only on file systems that are not case sensitive! InnoDB table names are stored in lowercase, as forlower_case_table_names=1.

在linux环境中想设置表名为大小写不敏感:

mysqld --SET-lower_case_table_names=1;

或者在mysql server的配置文件中添加配置项:

# The MySQL server

[mysqld]

set-variable=lower_case_table_names=1

参考链接