SQL 命令彙集

命  令

格    式

Select

Select   "欄位" From "表格名";

Where

Select "欄位" 

From "表格名" 

Where   "condition";

In

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

Like

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

Count

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

Group by

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

Create

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

Drop

DROP TABLE "表格名";

Truncate

TRUNCATE TABLE "表格名";

Update

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

比較

=、 <> 、 < 、> 、 >=、between

聚合

Count(欄位)、Ave、Sum、Max、Min

Distinct

Select Distinct "欄位" 

From "表格名";

And/OR

Select "欄位" 

From "表格名" 

Where "簡單條件" 

{[And|Or] "簡單條件"}+   ;

Between

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

Order By

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

Having

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

Insert

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

Delete

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

(Not) Like

*、_(底線)、%、[ABC]、Pattern

運算

+、-、*、/、%