User: sql-gotcha

Re:What about those [MySQL] gotchas?

On: MySQL 5.0 Candidate Released

That list addresses issues in MySQL 4.1 and earlier. Unfortunately I haven't had time to try out any of the MySQL 5.0 pre-release versions, so I'm not in a position to provided any kind of qualified commentary. However my impression is that many of the "gotchas" in the list have been addressed.

Re:will they fix gotchas too?

On: 'Most Important Ever' MySQL Reaches Beta

Err, RTFM? 13.1.8. Subquery Syntax. And an article too: Nesting SELECTs in MySQL 4.1. Note that this kind of statement:

DELETE FROM t1
WHERE id IN (SELECT MIN(id) FROM t1)

won't work though, at least as of 4.1.

Re:Obligitory MySQL Gotcha

On: The Definitive Guide to MySQL, 2nd Ed.

Hey, thanks!

Seriously though - if you find anything outdated (or just plain wrong) in the list, please tell me about it and I'll post updates. FWIW I gave it the once-over when 4.1 was certified as stable a few weeks back, but I may have missed something.

Disclaimer: despite appearances I do actually work with MySQL databases, and I'd be more than happy to see that list get smaller.