MySQL capitalization problem-sql-mode problem

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