一張表掌握所有核心 SQL 指令語法,適合開發時快速查閱。
查詢與篩選
| 指令 | 語法範例 |
| SELECT | SELECT col1, col2 FROM table WHERE condition; |
| SELECT * | SELECT * FROM table; |
| DISTINCT | SELECT DISTINCT col FROM table; |
| WHERE | WHERE col = val AND col2 > 10 |
| AND / OR | WHERE a=1 AND (b=2 OR c=3) |
| IN | WHERE col IN (1,2,3) |
| BETWEEN | WHERE col BETWEEN 10 AND 20 |
| LIKE | WHERE name LIKE 'A%' |
| ORDER BY | ORDER BY col DESC, col2 ASC |
| GROUP BY | GROUP BY col HAVING COUNT(*) > 5 |
| LIMIT / TOP | LIMIT 10 / TOP 10 |
連接查詢
| 類型 | 語法 |
| INNER JOIN | SELECT * FROM t1 INNER JOIN t2 ON t1.id = t2.t1_id |
| LEFT JOIN | SELECT * FROM t1 LEFT JOIN t2 ON t1.id = t2.t1_id |
| RIGHT JOIN | SELECT * FROM t1 RIGHT JOIN t2 ON t1.id = t2.t1_id |
| FULL JOIN | SELECT * FROM t1 FULL JOIN t2 ON t1.id = t2.t1_id |
資料操作 (DML)
| 指令 | 語法 |
| INSERT | INSERT INTO t (c1,c2) VALUES (v1,v2); |
| UPDATE | UPDATE t SET c1=v1 WHERE cond; |
| DELETE | DELETE FROM t WHERE cond; |
| TRUNCATE | TRUNCATE TABLE t; |
結構定義 (DDL)
| 指令 | 語法 |
| CREATE DATABASE | CREATE DATABASE db; |
| CREATE TABLE | CREATE TABLE t (id INT PRIMARY KEY, name VARCHAR(50)); |
| ALTER TABLE | ALTER TABLE t ADD col INT; DROP COLUMN col; |
| CREATE INDEX | CREATE INDEX idx ON t(col); |
| CREATE VIEW | CREATE VIEW v AS SELECT * FROM t; |
| DROP | DROP TABLE t; DROP DATABASE db; DROP INDEX idx; |
集合運算
SELECT * FROM t1 UNION SELECT * FROM t2; -- 去重合併
SELECT * FROM t1 UNION ALL SELECT * FROM t2; -- 保留重複
別名 (AS)
SELECT col AS alias FROM table;
SELECT * FROM table AS t;