Author Archives: user

MySQL – Delete Join Table of content Simple deletion operation in MySQL can be performed on a single entity or multiple entities of a table. But what if this deletion operation is to be performed on multiple entities of multiple tables? This is where Joins come into picture. MySQL DELETE… JOIN As we have discussed […]

MySQL – Update Join Table of content To update the data entered in a single database table using MySQL, you can use the UPDATE statement. However, to update the data in multiple database tables, we use the UPDATE… JOIN statement. MySQL UPDATE… JOIN Usually, JOINS in MySQL are used to fetch the combination of rows […]

MySQL – Full Join Table of content MySQL Full Join creates a new table by joining two tables as a whole. The joined table contains all records from both the tables and fill in NULLs for missing matches on either side. In short, full join is a type of outer join that combines the results […]