SQL句法

在这一页中，我们列出所有在这个网站有列出 SQL 指令的语法。若要更详尽的说明，请点选指令名称。

这一页的目的是提供一个简洁的 SQL 语法做为读者参考之用。我们建议您现在就按 Control-D 将本页加入您的『我的最爱』。

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

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

Where
SELECT "栏位"
FROM "表格名"
WHERE "条件";

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 "条件";