Lowercase Table Names in MySQL: Difference between revisions
Jump to navigation
Jump to search
(Created page with "Start <code>mysqld</code> with <code>-0 lower_case_table_names=1</code>. By default this option is 1 on Windows and 0 on Unix. The MySQL configuration file is <code>my.ini</c...") |
(No difference)
|
Latest revision as of 18:21, 24 February 2012
Start mysqld with -0 lower_case_table_names=1. By default this option is 1 on Windows and 0 on Unix.
The MySQL configuration file is my.ini. It's typically located in the Windows system directory (e.g. C:\WINNT\my.ini).
For case-sensitive table names to be the default MySQL option add this line to the my.ini file:
set-variable=lower_case_table_names=0
All the set-variable directives can be set this way.