Category Archives: mysql

Tips & Tricks

Monday, May 28th, 2007

Mysql Getting Random Row: “order by rand()”

Also filed in Uncategorized | | Permalink | Comments (0)

mysql case sensitive table name problem

Monday, June 12th, 2006

As the title suggests, this is about mysql on case sensitive filesystem on *nix Systems.
Situation is I had all my application written with SQL having uppercase table names.
But the mysql on linux had all in lowercase.
Quick Fix is to tell mysqlserver not to compare case while looking up table names
Edit /etc/my.cnf and add following [...]

Also filed in | | Permalink | Comments (0)