MySQL Complete Notes

Basic Query Structure

SELECT column1, column2
FROM table_name
WHERE condition;

Types of Joins

• INNER JOIN
• LEFT JOIN
• RIGHT JOIN
• FULL OUTER JOIN

Constraints

• PRIMARY KEY
• FOREIGN KEY
• NOT NULL
• UNIQUE