MySQL – Unique Key Table of content A Unique Key in MySQL, when applied on a certain field of a database table, does not allow duplicate values to be inserted in that column, i.e. it is used to uniquely identify a record in a table. Usually, any relational database contains a lot of information stored […]

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