Home >Database >Mysql Tutorial >Linux下MySQL忽略表名大小写_MySQL
Linux下MySQL忽略表名大小写_MySQL
- WBOYOriginal
- 2016-06-01 13:08:471098browse
用root帐号登录系统，编辑/etc/my.cnf，在[mysqld]下添加
lower_case_table_names=1
重启MYSQL服务，则可。
0：区分大小写，1：不区分大小写
1、数据库名与表名严格区分大小写；
2、表的别名严格区分大小写；
3、列名与列的别名在所有的情况下均忽略大小写；
4、变量名严格区分大小写。
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
Previous article：linux mysql 创建用户并授予权限_MySQLNext article：解决MySQL远程登录时出现ERROR 1130错误问题_MySQL