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,…
ODBC MySQL Data connection in Excel
After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…
PHP pagination: LIMIT in MySQL vs. FIRST / SKIP in FireBird
I got stuck writing a query for Firebird today. This is not the first time that the SQL was a…
MySQL TRIGGER
I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could…
MySQL simplicity
I spend a lot of time sanitising data. I use Microsoft Excel a lot of the time to perform most…
Restrict running of a MySQL Stored Procedure by time
I am creating an Excel Report that queries a MySQL database using an ODBC connection. The data is then returned…
Storing IP addresses in MySQL
I have always stored IP addresses as strings in VARCHAR fields in MySQL. I am currently reading “High Performance MySQL”…
Complex SQL query using SUM and GROUP BY
I got this question as part of a skills evaluation test. It requires a query to aggregate data from 2…