|
在 MySQL 中，数据库和表对就于那些目录下的目录和文件。因而，操作系统的敏感性决定数据库和表命名的大小写敏感。这就意味着数据库和表名在
Windows 中是大小写不敏感的，而在大多数类型的 Unix
系统中是大小写敏感的。 |
2.
在跨平台的程序设计中要注意到mysql的一些系统变量在windows和linux上的缺省值是不同的, 比如mysql表名称的大小写变量.
在windows上lower_case_table_names变量的缺省值为1; 在linux上为0; 在mac os上为2;
该变量值的详细定义如下:
| Value | Meaning |
|---|---|
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的配置文件中添加配置项:
vi /etc/my.cnf
- # The MySQL server
- [mysqld]
- set-variable=lower_case_table_names=1
# The MySQL server [mysqld] set-variable=lower_case_table_names=1
iefreer