Posts
All the articles I've posted.
Does MySQL need a COMMIT after INSERT? No, and that's the problem
The answer is no, MySQL autocommits by default. The interesting part is that typing COMMIT anyway raises no error, so a wrong mental model can survive for years.
Starting these notes
Why I'm writing things down in public, and what will end up here.
Why your JOIN returns more rows than either table
A JOIN that returns 40,000 rows from two tables of 200 usually means one thing. Underneath, every JOIN is a Cartesian product with a filter on top.