MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field aliases in the existing code and poked around a bit…
MySQL sub-query
I have blogged before about simplicity in code: how the simplest solutions are usually the best, and I normally put it down to elegance. I have the following table:tblTagstagID (int,…
Interbase query pain
One of the basic aims of Structured Query Language (“SQL”) is to provide a standard for interacting with databases. Unfortunately, most SQL code requires at least some changes before being…
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. Quite honestly the hardest part about this type of Microsoft…
MySQL simplicity
I spend a lot of time sanitising data. I use Microsoft Excel a lot of the time to perform most of the work — but I am slowly starting to use…