MySQL Gotchas

MySQL Gotchas: "It's not a bug - it's a gotcha. A "gotcha" is a feature or function which works as advertised - but not as expected. MySQL has an abundance of gotchas, which can cause much head-scratching to the uninitiated, particularly anyone coming from more fully-featured databases. They are evidently not bugs because they are mostly documented in the manual as known behaviour."