During my time as a web developer I’ve had the opportunity to work on some application that needed serious scalability. But scaling isn’t something we always think of when we set off to build an application. So, here’s a few tips I’ve picked up on the way that can help you build applications that are [...]
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 [...]
