常用 MySQL语法

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