Database Tips

From Opentaps Wiki
Revision as of 19:14, 13 March 2008 by Sichen (talk | contribs) (Protected "Database Tips": Sysop page [edit=sysop:move=sysop])
Jump to navigationJump to search

Database Tips and Tricks


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 &

See MySQL manual on identifier case sentivity