SQL語法

在這一頁中，我們列出所有在這個網站有列出 SQL 指令的語法。若要更詳盡的說明，請點選 指令名稱。

這一頁的目的是提供一個簡潔的 SQL 語法做為讀者參考之用。我們建議您現在就按 Control-D 將本 頁加入您的『我的最愛』。

Select
SELECT "欄位" FROM "表格名";

Distinct
SELECT DISTINCT "欄位"
FROM "表格名";

Where
SELECT "欄位"
FROM "表格名"
WHERE "condition";

And/Or
SELECT "欄位"
FROM "表格名"
WHERE "簡單條件"
{[AND|OR] "簡單條件"}+ ;

In
SELECT "欄位"
FROM "表格名"
WHERE "欄位" IN ('值1', '值2', ...);

Between
SELECT "欄位"
FROM "表格名"
WHERE "欄位" BETWEEN '值1' AND '值2';

Like
SELECT "欄位"
FROM "表格名"
WHERE "欄位" LIKE {模式};

Order By
SELECT "欄位"
FROM "表格名"
[WHERE "條件"]
ORDER BY "欄位" [ASC, DESC];

Count
SELECT COUNT("欄位")
FROM "表格名";

Group By
SELECT "欄位1", SUM("欄位2")
FROM "表格名"
GROUP BY "欄位1";

Having
SELECT "欄位1", SUM("欄位2")
FROM "表格名"
GROUP BY "欄位1"
HAVING (函數條件);

Create Table
CREATE TABLE "表格名"
("欄位 1" "欄位 1 資料種類",
"欄位 2" "欄位 2 資料種類"",
... );

Drop Table
DROP TABLE "表格名";

Truncate Table
TRUNCATE TABLE "表格名";

Insert Into
INSERT INTO "表格名" ("欄位1", "欄位2", ...)
VALUES ("值1", "值2", ...);

Update
UPDATE "表格名"
SET "欄位1" = [新值]
WHERE "條件";

Delete From
DELETE FROM "表格名"
WHERE "條件";