SQL语法

dashan 提交于

在这一页中，我们列出所有在这个网站有列出 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 "条件";