In Linux, Mysql uses case-sensitive bitsCN.com
In Linux, Mysql is case-sensitive. 1. After mysql is installed in Linux, it is the default value: case-sensitive for table names, not case-sensitive for column names. 2. after logging on with the root account, in/etc/my. add "lower_case_table_names = 1" after [mysqld] in cnf and restart the MYSQL service. The settings are successful: case insensitive to table names; lower_case_table_names parameter description: lower_case_table_names = 0 0: case-sensitive. 1: case-insensitive MySQL uses the following naming rules for database names, table names, column names, and aliases in Linux: 1. database names and table names are case-sensitive; 2. table aliases are case-sensitive. 3. column names and column aliases are case-insensitive in all cases. 4. variable names are case-sensitive; mySQL is case insensitive in Windows. BitsCN.com
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.
