When MySQL Bites: Quirks to Watch Out For
By Smylers from Leeds.pm
Date: Thursday August 14, 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.
- Barbie
- Smylers
- Paul-Christophe Varoutas
- Henrik Hald Nørgaard
- Chisel Wright (Chiz)
- RichA
- Morten Meyling
- Espen Myhre (espenmy)
- Andrew Bayliss
- Imran Chaudhry
- Salve J. Nilsen
- Jason Tang (Jase)
- Christian Borup (borup)
- Dave Cross (davorg)
- Henrik Tougaard (htoug)
- David Leadbeater (dgl)
- Roberto Henríquez
- Tobias Henoeckl (hoeni)
- Lars Jorgensen
- Rune Mydske Nielsen (runeni)
- Bern
- Cecilie Fritzvold
- Darius Jokilehto
- Cristina Nunes (mega)
- Aristotle Pagaltzis
- Nicholas Clark
- Mads Gudmand-Høyer
- Mårten Svantesson
- Søren Lund (slu)
- Trond Michelsen (trondmm)
- Jos Boumans (kane)
