简洁的sql语法

https://www.1keydata.com/cn/sql/sql-sitemap.php

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