When MySQL Bites: Quirks to Watch Out For

By Smylers from northwestengland.pm
Date: Thursday, 14 August 2008 15:10
Duration: 30 minutes
Language:
Tags: databases mysql rant sql tips

MySQL is a very popular DBMS. Or rather, it's very widely used, which is not necessarily the same thing. It has quite a few quirks, behaviour that many people wouldn't expect and which if you aren't aware of can be the cause of much frustration, pain, and data loss.

In the hope that more people being aware of these infelicities will reduce the damage they can do, a collection of them is presented here, along with tips and techniques for dealing with them.

There's also an examination of why so often the MySQL feature is tantalizingly only available in one version higher than the one you're running.