This list of MySQL Gotchas can come in handy. It also points out some interesting design decisions by the MySQL folks. Some of which are quite annoying.