In the past, oracle databases were used for enterprise projects and mysql was used for new company projects.
1 In windows, mysql is case-insensitive by default. To make mysql case-insensitive. Change Method
Find the my. ini file in the mysql installation directory and add the following at the end of the file:
Lower_case_table_names = 0
Restart the mysql service.
2 in linux, the configuration file is case-sensitive by default and can be modified.
Log on to the root account and modify/etc/my. cnf or/etc/mysql/my. cnf.
Lower_case_table_names = 1 # case insensitive
Lower_case_table_names = 0 # case sensitive
Restart mysql Service
/Etc/init. d/mysql restart
Note:
If my cannot be found in/etc or/etc/mysql. for cnf, you need to find it under/usr/share/mysql *. copy one of the cnf files to/etc/and change it to my. cnf and put it under/etc.
Cp/usr/share/mysql/my-*. cnf/etc/my. cnf