I. MySQL field name table name database names are case-sensitive
Today encountered database capitalization issues, Linux and Windows issues
At the same time, they touch the reserved word
Http://www.cnblogs.com/lawdong/archive/2010/08/08/2357903.html (collected by others. You can see what the reserved words are.
The following is the results of my test:
Under Linux operating system
Database default is case sensitive
Table name default is case sensitive
Field name default is case insensitive
Under Windows operating system
Database is case insensitive
Table names are case insensitive
Field names are case insensitive
The root cause is that there is a field control in the configuration
Windows;
1 Representative do not differentiate
0 Representative Case Sensitive
Linux
Suddenly found that the code is different. Field case sensitivity is not the same
Details Address:
http://imysqldba.blog.51cto.com/1222376/1304539
How to make changes please Google yourself
The distinction between strict and non-strict modes of 2.mysql
For details, please see
Http://www.jb51.net/article/51900.htm
MySQL capitalization problem-sql-mode problem