Setting MySQL in Linux does not differentiate table name capitalization

1.

The table name of the MySQL database is strictly case-sensitive under the Linux system, and the program developed under the Windows system is ported to the Linux system, and if the SQL statement in the program does not access the database table strictly by case, there may be an error that the table could not be found.

2.

The workaround is to modify the MySQL configuration file my.cnf, add the following configuration options in the [mysqld] section lower_case_table_names = 1, restart the MySQL service.

3.

But this approach is not a cure, the fundamental solution is to follow the good practice of cross-platform development, such as the library name, table name, field name, etc. in the SQL statement to be strictly case-sensitive, with the database name, table name, field name of the case exactly match, this will enhance the portability of the program. Avoid modifying the configuration of the deployment target environment, which may cause other apps to have no effect if the target environment deploys other applications.

Original link: http://reiz6153.blog.163.com/blog/static/40108915201110923246233/

Setting MySQL in Linux does not differentiate table name capitalization