Have you ever had the need to do a MySQL find and replace to quickly replace some data in your database? Fear not, MySQL has a nifty little string function, REPLACE, that allows a user to find and replace instances of a search string with a substitution string.
[ Read More ]
Working with WordPress, I often will take a production database and restore it to my local server to verify changes and further aid in development. When doing so, I will always run WordPress under a named virtual host, with frequent production backups allowing me to mimic the production environment. This article will discuss the steps necessary to backup and restore a production MySQL database to a local development environment, and configure it to run against a local named virtual host or URL.
[ Read More ]
I was recently working on a project at work and needed to do some debugging on a local environment of the queries being executed against a MySQL database from the application I was working on. To accomplish this, I used the MySQL general query log, and wanted to share how to enable and configure the general query log.
[ Read More ]
I was recently asked by a team member how to go about deleting records from a table based on an arbitrary composite key that was determined by the results of separate query that leveraged one or more tables, and I figured I’d post this solution for everyone.
[ Read More ]
Working on a recent project, I had a task that required me to number the rows of result set; however, I needed to reset the numbering based on the distinct value of a field, or group of fields. I accomplished my task by leveraging ROW_NUMBER() and PARTITION BY.
[ Read More ]
