by Yahwho | 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 remembered from Uni days (when beer and having fun was more important than learning about RDBMS’). I know enough to get by, but...
by Yahwho | 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 MySQL that I know of is PostgreSQL. So I thought I would take a peek at the data and see what other people are using (and therefore...
by Yahwho | 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 MySQL has a lot of benefits. The biggest of which is the ability to populate it with data and test it as you go, not...
by Yahwho | 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 my new project. A little different from before as you now need need to add a preceding sql to the command. Looks like...