Category: MySQL

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…