Insert 新增一筆紀錄

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

※最後要有一個分號作結束，字串的值以單引號包含，數字不用。

例：INSERT INTO Store_Information (Store_Name, Sales, Txn_Date) VALUES ('Los Angeles', 900, 'Jan-10-1999');

※新增的欄位來自另一個資料表：

INSERT INTO "表格1" ("欄位1", "欄位2", ...) SELECT "欄位3", "欄位4", ... FROM "表格2";

Update 更新一筆紀錄

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

例：UPDATE Store_Information SET Sales = 500 WHERE Store_Name = 'Los Angeles' AND Txn_Date = 'Jan-08-1999';

Update 更新多筆紀錄

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

※符合條件紀錄的欄位均會被更新。

Delete 刪除紀錄

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

例：DELETE FROM Store_Information WHERE Store_Name = 'Los Angeles';

Select 選擇紀錄

SELECT "欄位名稱" FROM "表格名稱" [WHERE 符合條件]

排序：遞增、遞減

SELECT * FROM table WHERE ID is not null ORDER BY ID

或 ORDER BY ID Desc