阅读背景:

如何在MySql中强制执行区分大小写的表和列名称?

来源:互联网 

The thing is we are working on windows machine and once done we deploy the code on unix machine. The code works fine on windows but then in unix we get the error like 'no such table exists' after changing the table name in correct case it works fine in unix too. Actually, in windows there is no case sensitive table names by default but in unix they do have ( read that MySQL tables are actually files and in unix we have case sensitive file name but not in windows ). Workaround could be to create all tables again and lets have the table name in lowercase. Yes, we can do that too, thats fine.The thing is we are working on windows machine




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: