Archive for “MySQL Code”

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

5 Sep 2017

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

2 Feb 2017

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

23 Nov 2016

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

7 Oct 2015

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

29 Sep 2015

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

27 Apr 2015

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

6 Oct 2014

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

15 Apr 2014

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

11 Sep 2013

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

22 Jul 2013

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