Home >Database >Mysql Tutorial >Linux下MySQL忽略表名大小写_MySQL

Linux下MySQL忽略表名大小写_MySQL

WBOY
WBOYOriginal
2016-06-01 13:08:471098browse


用root帐号登录系统,编辑/etc/my.cnf,在[mysqld]下添加

lower_case_table_names=1

重启MYSQL服务,则可。


0:区分大小写,1:不区分大小写


Linux下MySQL大小写规则:
1、数据库名与表名严格区分大小写;
2、表的别名严格区分大小写;
3、列名与列的别名在所有的情况下均忽略大小写;

4、变量名严格区分大小写。


另:Windows下都不区分大小写。
Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn