I needed to update a WordPress taxonomy on a site with thousands of categories and tags. This is not a task for a human, so I created a bit of a gnarly SQL script to update the MySql table. As you can see from the script, it has limitations! Specifically, if you need it to […]
You can subscribe to the mysql tag micro-feed.
It is often useful to have a column that indicated the last update date of a record on a table. It is also useful to update this column automatically, rather than having to rely on the application updating the value. There is a really simple way to do this in MySql, using a column defined […]