Category Archives: MySQL
Exploring Triggers in MySQL and PostgreSQL
Recently I was working on a car maintenance database. The database stores, among other things, odometer reading, miles per fill up, number of gallons per fill up, and cost per gallon. One of the missing pieces of information I wanted … Continue reading
How to change your Amazon Associates ID in WordPress posts
You may find yourself, for one reason or another, needing to update your amazon affiliate links in your WordPress posts to reflect a new tracking id. Depending on the number of posts your are dealing with, doing this by hand … Continue reading
Implementing Zip Code Proximity Functions in MySQL and PostgreSQL
On most retail and social networking websites (along with many others), you’ll have the capability to search for people, businesses, store locations, etc within a given distance of your location. This can be implemented in a number of ways both … Continue reading