Installing the MySQL Installer on Windows
Installing MySQL on a Windows machine is a breeze with the MySQL Windows Installer. The installer is a utility allowing…
productivity through technology
Installing MySQL on a Windows machine is a breeze with the MySQL Windows Installer. The installer is a utility allowing…
This post details backing up a MySQL database using a cron job and mysqldump on a Centos box.
This post is aimed at Information Technology (“IT”) students in DBE and IEB schools. When learning the Structured Query Language…
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field…
I have blogged before about simplicity in code: how the simplest solutions are usually the best, and I normally put…
One of the basic aims of Structured Query Language ("SQL") is to provide a standard for interacting with databases. Unfortunately,…
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. This is not the first time that the SQL was a…
I battled for ages to find the correct syntax to create a trigger in MySQL — the examples I could…
I spend a lot of time sanitising data. I use Microsoft Excel a lot of the time to perform most…