---
tags: sql mysql
---

# SQL語法介紹

## SQL的用途與方法


## SQL語法的分類

#### DDL(Data Definition Language) - ==資料定義語言==

* CREATE, ALTER, DROP

#### DML(Data Manipulation Language) - ==資料操縱語言==

* SELECT, INSERT, UPDATE, DELETE

#### DCL(Data Control Language) - ==資料控製語言==

* GRANT, REVOKE

> 案例


SELECT * FROM Customers
WHERE City IN ('Paris','London');

select id, name
from user
where age > 18;