SQL

Universal Rules of SQL syntax

• It can be written in single / multiple line. But must end with ;.
• SQL allow using space or new line to increase readability.
• SQL syntax of MySQL is not case-sensitive. But encourage to using Capital Letter.

Types of SQL syntax

Types of SQL Syntax	Description	Keywords
DDL - Structural Blueprint (Databases & Tables)	Use to define database, tables, index, ...	CREATE, ALTER, DROP, RENAME
DML - Content Management (Data Entries)	Use for add, update, delete operation towards DB	INSERT, UPDATE, DELETE
DQL - Finds the data	Use for query, find data record on DB.	SELECT
DCL - Access control	Use for control DB, create user and control the access permission	SHOW, DESCRIBE, EXPLAIN