When MySQL Bites: Quirks to Watch Out For

When MySQL Bites: Quirks to Watch Out For

By Smylers from northwestengland.pm
Date: Thursday, 14 August 2008 15:10
Duration: 30 minutes
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.

Attended by: Nicholas Clark, Paul-Christophe Varoutas, Barbie, Salve J. Nilsen (‎sjn‎), Dave Cross (‎davorg‎), Jos Boumans (‎kane‎), Smylers, Roberto Henríquez, Christian Borup (‎borup‎), Søren Lund (‎slu‎), Trond Michelsen (‎trondmm‎), Espen Myhre (‎espenmy‎), Henrik Tougaard (‎htoug‎), Tobias Henoeckl (‎hoeni‎), Chisel Wright, Aristotle, Cristina Nunes (‎mega‎), Rune Mydske Nielsen (‎runeni‎), Bern, David Leadbeater (‎dg‎), Lars Jorgensen, Dominic Hargreaves (‎Dom‎), Cecilie Fritzvold, Imran Chaudhry (‎icjs‎), Jason Tang (‎jason‎), Mårten Svantesson, Darius Jokilehto, Andrew Bayliss, Henrik Hald Nørgaard, Morten Meyling, RichA, Mads Gudmand-Høyer,