SyntaxHighlighter

2012-11-08

About the Table name Case Sensitivity in MySQL

It confused me for a while.
With the MySQL server which is installed in Windows, the tables' name and schemas' name are all case insensitive.

It means, if you try to make a table name as tblSomething,
it will be named as tblsomething.

As the official answer,
the MySQL server in Mac and Windows save TABLEs case insensitive because the filesystem is case insensitive.

so, don't waste your time to rename the TABLEs try to make the name case sensitive.
it won't work

0 件のコメント:

人気の投稿