INSERT INTO 資料表 (欄位1, 欄位2, ...)
VALUES (值1, 值2, ...);
範例:
INSERT INTO employee (firstname, lastname, age, address, city)
VALUES ('Li', 'Ming', 45, 'No.77 Changan Road', 'Beijing');
UPDATE 資料表
SET 欄位1 = 新值1 [, 欄位2 = 新值2 ...]
WHERE 條件運算式 [AND|OR 條件運算式];
範例:Mary Williams 年齡加 1
UPDATE employee
SET age = age + 1
WHERE first_name = 'Mary' AND last_name = 'Williams';
關鍵:WHERE 條件決定影響範圍,省略 WHERE 將更新全表。
DELETE FROM 資料表
WHERE 條件運算式 [AND|OR 條件運算式];
範例:刪除姓氏為 May 的員工
DELETE FROM employee WHERE lastname = 'May';
省略 WHERE 將刪除資料表所有列,請極度謹慎。