A detail of the default requirements for table name capitalization under Windows and Linux for MySQL

Build the project environment in the virtual machine today, steal the lazy, directly copy the table in the native database to the database in the virtual machine, then start the project, project one start prompt: SQLyog

Table ' sdmqrt. Qrtz_locks ' doesn ' t exist

I can not find the table, strange Ah, my native database can not be a little table ah, check the virtual machine in the table also does exist. The problem is coincidentally in the Qrtz_locks table, that is, the dispatch task table, Spring quartz happens to have a bug, and then I fell into that bug, I do not know this bug can be directly Baidu .

According to the method of how to deal with the bug, and I also suspect that this machine is good how can be a bug in the virtual machine. All kinds of toss no solution, helpless directly find database build library script to execute again, and then suddenly found a problem, the database appears in uppercase table name and lowercase table name, I instantly think of a possible, re-execute the program is normal.

Then Baidu confirmed my guess: Linux under the default is the table name of the difference between the case, this is not the same as under Windows, this default processing is very strange. As for the change to the case-insensitive this Baidu a bit is not listed.

A detail of the default requirements for table name capitalization under Windows and Linux for MySQL