您好,登錄后才能下訂單哦!
[mysqld]
lower_case_table_names=1
參考文檔:
lower_case_table_names
Property | Value |
---|---|
Command-Line Format | --lower-case-table-names[=#] |
System Variable | lower_case_table_names |
Scope | Global |
Dynamic | No |
Type | integer |
Default | 0 |
Minimum | 0 |
Maximum | 2 |
If set to 0, table names are stored as specified and comparisons are case-sensitive.
If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.
If set to 2, table names are stored as given but compared in lowercase. This option also applies to database names and table aliases.
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).
It is an unsupported combination that could result in a hang condition when running an INSERT INTO ... SELECT ... FROM tbl_nameoperation with the wrong tbl_name letter case. With MyISAM, accessing table names using different letter cases could cause index corruption.
As of MySQL 5.7.9, an error message is printed and the server exits if you attempt to start the server with --lower_case_table_names=0 on a case-insensitive file system.
If you are using InnoDB tables, you should set this variable to 1 on all platforms to force names to be converted to lowercase.
The setting of this variable in MySQL 5.7 affects the behavior of replication filtering options with regard to case sensitivity.
免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。