关于MySQL的表名的大小问题,解决办法:
(1)找到{%MySQL_Home%}目录下的my.ini文件。
(2)在[mysqld] section尾部修改参数lower_case_table_names的值。
[table]
|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. This is the default on Unix systems. Note that if you force this to 0 with --lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM
tablenames using different lettercases, this may lead to index corruption.
|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 as of MySQL 4.0.2, and to table aliases as of 4.1.1. This value is the default
on Windows and Mac OS X systems.
|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. Note: This works only on filesystems that are not case
sensitive! InnoDB table names are stored in lowercase, as for lower_case_table_names=1. Setting lower_case_table_names to 2
can be done as of MySQL 4.0.18.
[/table]
(1)找到{%MySQL_Home%}目录下的my.ini文件。
(2)在[mysqld] section尾部修改参数lower_case_table_names的值。
[table]
|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. This is the default on Unix systems. Note that if you force this to 0 with --lower-case-table-names=0 on a case-insensitive filesystem and access MyISAM
tablenames using different lettercases, this may lead to index corruption.
|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 as of MySQL 4.0.2, and to table aliases as of 4.1.1. This value is the default
on Windows and Mac OS X systems.
|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. Note: This works only on filesystems that are not case
sensitive! InnoDB table names are stored in lowercase, as for lower_case_table_names=1. Setting lower_case_table_names to 2
can be done as of MySQL 4.0.18.
[/table]