// archives

Archive for November, 2007

Elliot? - Who the hell is Elliot?

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 users AS u
LEFT [...]