Category Archives: mysql

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 – 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 – Union vs Join Table of content MySQL provides various relational operators to handle data that is spread across multiple tables in a relational database. Out of them, UNION and JOIN queries are fundamentally used to combine data from multiple tables. Even though they are both used for the same purpose, i.e. to combine […]