In this MySQL tutorial, we will continue with a DOUBLE JOIN and discuss UPDATES and DATA MANIPULATION. We will also have a look at some different JOIN types.
Tag archives: Databases - Page 1
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.
Following on my previous article on databases and database planning, I have decided to add a quick practical tour of a MySQL database. We will assume that you have access to a MySQL/MariaDB server and have sufficient rights to create and edit a database.
In this article, we discuss the importance of planning your SQL database structure so that you can hit the road running.