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