Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how the table names of MySQL under Linux are not case-sensitive". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

When I was testing today, I encountered some problems. I obviously saw the data, but I couldn't find it out. Later, I found that under linux

The table name of mysql is case-sensitive, but it is not case-sensitive. Data scripts exported from windows use lowercase.

The table name in the sql generated by Hibernate is uppercase, so the data cannot be found.

Google has some information, and you can modify a parameter of mysql, as follows:

Under ubuntu, in the / etc/mysql/my.cnf file

Add after [mysqld]

Lower_case_table_names=1

0, case-sensitive; 1, insensitive

It also seems to say that in / etc/my.cnf, under ubuntu, this cannot be used.

Www.2cto.com

Then restart mysql

Sudo / etc/init.d/mysql restart

Note: (the following is excerpted from the Internet)

The case rules for MYSQL's name, table name, column name and alias in LINUX are as follows:

1. Database names and table names are strictly case-sensitive

two。 Aliases for tables are strictly case sensitive

3. Column names and column aliases are case ignored in all cases

4. Variable names are also strictly case-sensitive

MYSQL is case-insensitive under WINDOWS.

This is the end of the content of "how the table names of MySQL under Linux are not case-sensitive". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.