MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field…
MySQL sub-query
I have blogged before about simplicity in code: how the simplest solutions are usually the best, and I normally put…
Interbase query pain
One of the basic aims of Structured Query Language (“SQL”) is to provide a standard for interacting with databases. Unfortunately,…
Creating TOTALS in Access queries
In Grade 12 one of the most advanced skills you will learn is how to aggregate data using a query.…
MySQL simplicity
I spend a lot of time sanitising data. I use Microsoft Excel a lot of the time to perform most…