Whitney  Durgan

Whitney Durgan


Types of MySQL Joins | MySQL Joins [With Syntax]


MySQLis an open-source Relational Database Management System (RDBMS) backed by Oracle. MySQL is made up of two words- “My”, the name of co-founder Michael Widenius’s daughter, and “SQL”, the abbreviation for Structured Query Language.

The word Relational in RDBMS is the fundamental on which JOINS in MySQLwork. There can be many types and numbers of tables in any Database. JOINS as the name suggests link tables together using common columns. One basic example is, Table 1 has employee details and Table 2 has project details.

If we have to check the projects an employee is involved in, we can join the tables on employee name or employee id, hence doing so will join the tables and the new virtual table (can be saved) can be accessed with all the information required.

#sql #sql joins #mysql #mysql joins

Types of MySQL Joins | MySQL Joins [With Syntax]