当前位置: 动力学知识库 > 问答 > 编程问答 >

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 instructions ?

网友答案:

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.

分享给朋友:
您可能感兴趣的文章:
随机阅读: