SQL | Yahwho.org

Delete a Foreign Key if exists

Dec 19, 2020 | SQL

I'm currently developing a new database, requiring the initialisation code to be run over and over again. Creating tables with IF EXISTS...

Nov 21, 2020 | SQL

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...

Oct 27, 2020 | SQL

No tech updates since October the 16th huh? Well, I realised that my SQL skills were somewhat limited to some basic stuff I still...

Oct 14, 2020 | SQL

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...

Oct 13, 2020 | SQL

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...

Sep 22, 2020 | SQL

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...