CREATE DATABASE statement syntax
What would seem like a complex task — creating a new database — is possibly the simplest statement of all:…
Database tools for learning SQL
Information Technology students must learn Structured Query Language (“SQL”). As Microsoft Access’ SQL often deviates from standard SQL, I started…
CREATE TABLE syntax
This post is aimed at Information Technology (“IT”) students in DBE and IEB schools. When learning the Structured Query Language…
MySQL column aliases
In the process of refactoring some MySQL queries in some PHP code, I came across some interesting syntax for field…