Mysql Getting Random Row: “order by rand()”
-
‹ Home
Contents
-
Categories
-
Tags
-
Archives
Blogroll
-
RSS Feeds
-
Meta
Category Archives: mysql
mysql case sensitive table name problem
Monday, June 12, 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 [...]