After swatting up on connecting QlikView to a MySQL database, I used the knowledge gained to create a similar set-up,…

I got stuck writing a query for Firebird today. And here I was thinking that SQL was a standard — if…

I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could…

I love the fact that the best solutions are almost always the simplest! I spend a lot of time sanitising…

I am creating an Excel Report that queries a MySQL database using an ODBC connection. The data is the returned…

I have always stored IP addresses as strings in VARCHAR fields in MySQL. I am currently reading “High Performance MySQL”…

Got this question as part of a skills evaluation test. It requires a query to calculate summary-like data from tables…