Archive for “MySQL Code”

MySQL commands and SQL queries to help you manage your MySQL databases and tables.

February 15, 2018

This is an example of how to use the GeoNames data dump … Read more →

August 27, 2018

There is some bad advice going around regarding updating URLs in the … Read more →

February 6, 2018

These SQL queries let you change the value for “siteurl” option in … Read more →

April 23, 2018

These are my most often-used MySQL commands and queries. Connect to MySQL … Read more →

March 12, 2017

These are the terminal commands to reset your MySQL password for your … Read more →

February 22, 2017

These are SQL queries to change the home url in the wp_options … Read more →

February 2, 2017

This is useful if you created custom menu links for your WordPress … Read more →

April 11, 2015

These are MySQL statements to bulk delete all WordPress attachments of a … Read more →

February 14, 2018

Updated to use MySQL transactions, prepared SQL statments, and bound parameters. This … Read more →

October 8, 2014

This is for you if you are using the WordPress Comment Notifier … Read more →