WAMP (& LAMP)
Setting up a dev box with Apache HTTP Server, PHP and MySQL is an important skill for any web developer.…
DROP DATABASE statement
Equally as simple as the CREATE DATABASE statement, the DROP DATABASE statement will destroy an entire database. This tutorial uses…
CREATE USER & GRANT PRIVILEGES in MySQL
A MySQL database has a default, root user that is able to do anything on the server and to the…
Updating with MySQL Installer on Windows
The MySQL Installer is a simple and intuitive utility for managing your MySQL database needs. I use it on my…
Installing phpMyAdmin
phpMyAdmin is used to administer a MySQL database over the Internet; it is a crucial tool that web hosting companies…
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…
How to Backup a MySQL Database automatically on Linux
This post details backing up a MySQL database using a cron job and mysqldump on a Centos box.
CREATE DATABASE statement
What would seem like a complex task — creating a new database — is possibly the simplest statement of all!…
CREATE TABLE statement
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…