Category Archives: mysql

MySQL – Self Join Table of content MySQL Self Join The MySQL Self Join is used to join a table to itself as if the table were two tables. To carry this out, at least one table is temporarily renamed in the MySQL statement. Self Join is a type of inner join, which performed in […]

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 […]

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 […]