Difference between revisions of "Database Tips"
From Opentaps Wiki
Jump to navigationJump to search (New page: __TOC__ ==Database Tips and Tricks== ===MySQL=== ====Table Name Case Sensitivity==== If you use Linux or Unix for your MySQL server, the table names may be case sensitive, so PRODUCT a...) |
m (Protected "Database Tips": Sysop page [edit=sysop:move=sysop]) |
(No difference)
| |
Revision as of 19:14, 13 March 2008
Database Tips and Tricks
MySQL
Table Name Case Sensitivity
If you use Linux or Unix for your MySQL server, the table names may be case sensitive, so PRODUCT and product are not the same table. You can turn this off by configuring mysqld on startup to ignore table names with the lower-case-table-names flag, such as this example from /etc/init.d/mysql:
$bindir/mysqld_safe --datadir=$datadir --lower-case-table-names=1 --pid-file=$server_pid_file $other_args >/dev/null 2>&1 &
