The default Requirements for the Case sensitivity of Mysql tables in windows and linux are as follows:

The default Requirements for the Case sensitivity of Mysql tables in windows and linux are as follows:

Today, I set up a project environment in a virtual machine. I stole my laziness and copied the tables in the local database to the database in the virtual machine using sqlyog. Then I started to deploy the project. When I started the project, the following message was displayed:

Table 'sdmqrt. QRTZ_LOCKS 'doesn' t exist

I can't find the table. It's strange that my local database cannot have fewer tables. Check whether the table in the virtual machine exists .. the problem happened to be the qrtz_locks table, that is, the scheduling task table. spring quartz happened to have such a bug, and then I fell into the bug, if you are not clear about this bug, you can directly use Baidu.

I am also skeptical about how to handle the bug. How can a bug occur in a virtual machine .. after a variety of twists and turns, I had no choice but to directly find the database creation script and execute it again. Then I suddenly found a problem. The database showed the upper-case and lower-case table names. I thought of a possibility instantly, re-execute the program ..

Then Baidu confirmed my guess: mysql in linux is case-sensitive by default, which is different from that in windows. The default processing method is very strange .. if it is changed to case-insensitive, Baidu will not list some of them.