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…
productivity through technology
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…
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,…
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…
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…
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…