开发者

Setting MySQL "lower_case_table_name" server variable

Running MYSQL 5.1 on windows 7. . . how do I change the server variable for 'lower_case_table_names'. Need to set it to 0. I've tried to set it from the command prompt using mysqld.exe, and I've tried manually changing the my.ini file. . . no luck.

Does anyone have some sure-fire/straight-forward do-this, and then this instru开发者_如何学运维ctions ?


Figured it out. . . couldn't change the variable w/ mysql workbench running. Closed it out, restarted the service and the changes took effect. Weird.


As far as I know this will only affect new tables, existing tables will not be affected by this property.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜