Skip to content

Category Archives: mysql

Tips & Tricks

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

  • Share/Bookmark

mysql case sensitive table name problem

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 [...]

  • Share/Bookmark