When MySQL Bites: Quirks to Watch Out For

When MySQL Bites: Quirks to Watch Out For

By Smylers from northwestengland.pm
Date: Saturday, 3 October 2009 14:00
Duration: 40 minutes
Language: English
Tags: databases mysql rant sql tips

You can find more information on the speaker's site:


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.


Attended by: Frédéric Bruyère (‎Fredb‎), Frédéric Marand (‎OSInet‎), Laurent Jourdren, Olivier Duclos (‎odc‎), Viktor Horvath, Kai Carver (‎kai‎), Smylers, Alexandre Jousset (‎Mid'‎), Nils Grunwald, Grégoire Baron (‎baronchon‎), Camille Maussang (‎cmaussan‎), Sébastien Aperghis-Tramoni (‎Maddingue‎), Philippe Bruhat (‎BooK‎),