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.
Elliot? – Who the hell is Elliot?
Read the Full Story »
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 users AS u
LEFT [...]