MYSQL pairs indicate case-sensitive

MYSQL statement is case-insensitive. It is depressing today. In LINUX, if a program is downgraded, the table cannot be found, but the table is clearly created and can be found in the MYSQL command line, why can't the program find the table ?? Later, I asked a teacher to solve the problem. It turns out that MYSQL in LINUX is case sensitive by default.

MYSQL statement is case-insensitive. It is depressing today. In LINUX, if a program is downgraded, the table cannot be found, but the table is clearly created and can be found in the MYSQL command line, why can't the program find the table? ? Later, I asked a teacher to solve the problem. It turns out that MYSQL in LINUX is case sensitive by default.

MYSQL pairs indicate case-insensitive

Today, I am depressed. I used to downgrade a program in LINUX and said I couldn't find the table, but I obviously created the table. I can also find it under the MYSQL command line, why can't the program find the table?

?

Later, I asked a teacher to solve the problem. It turns out that MYSQL in LINUX is case-sensitive by default. Well, it's so old that it's killing me.

The case-insensitive MYSQL method is actually very simple:

1. Log On with ROOT and modify/etc/my. cnf

2. Add a row under [mysqld]: lower_case_table_names = 1

3. Restart the database.