Blog
In our previous MySQL tutorial, we did some basic SELECT queries, a CONCAT for output and a JOIN to lookup data on a different table that was linked or RELATED to our client database. In this MySQL tutorial, we will continue with a DOUBLE JOIN and discuss UPDATES and DATA MANIPULATION. We will also have a…
Read More »In our previous MySQL tutorial, we created a small database with four tables. In this article, we will learn to manipulate the data we entered using JOIN to derive data from a table using data from another table. We will also modify the output using the MySQL CONCAT command. Our MySQL Data Our data consists…
Read More »Following on my previous article on databases and database planning, I have decided to add a quick practical tour of a MySQL database. MySQL and MariaDB are equivalent for the purpose of this article as they both use the exact same syntax. We will assume that you have access to a MySQL/MariaDB server and have…
Read More »This article is not from a professional SQL Database Administrator’s perspective. It is from someone who has been using MySQL, PostgreSQL and MariaDB for the last 18 years. I have found some basic principles around database design that make life a lot easier. And then researched the best practice whitepapers to confirm the soundness of that…
Read More »
What database options are there ? When it comes to a database for your server, there are many more options than just Microsoft SQL. As we all know Linux users have a free choice of database options. Less known is that Microsoft Server users also have a choice. Instead of paying a fortune for MS…
Read More »