Completed SQL Quests
Delete a Foreign Key if exists
I'm currently developing a new database, requiring the initialisation code to be run over and over again. Creating tables with IF EXISTS...
Todays MySQL Timestamp Learnings
Today I have decided to take a look at the redesign of the Medieval Realms database. This is the first production database I've ever...
Databases, databases, databases
No tech updates since October the 16th huh? Well, I realised that my SQL skills were somewhat limited to some basic stuff I still...
RDBMS’
So I decided to slam the brakes on MySQL and do some research into RDBMS before I got too involved again. The next biggest RDBMS next to...
MySQL Workbench Database Design
So I'm designing a database in MySQL Workbench for the first time. Previously they've all been on scraps of paper. Designing a database in...
Back to Basics – MySQL
So it's been a few years now since I created a database in MySQL (version 6 in fact). I installed the latest version MySQL - version 8 for...