I’ve finally got round to writing an ‘about‘ page on my site. If you’re interested in finding out a little bit more about me, check it out.
MySQL: DELETE across multiple tables using JOIN.
Ever had a situation where you’ve wanted to say delete rows from lots of tables in your database that can all be associated with some form of join? Well, after a few minutes of playing around, I’ve found a nice way to do this in just 1 query: DELETE u, up, upc, ut, utp FROM [...]