Insert

Insert新增資料

• Workbench用法：點選表格 > 滑向右邊第3個按鈕 > 表格右鍵 > Select Rows

################# 語法如下:
INSERT INTO tablename(col1, col2) VALUES(value1, value2);

################# 範例如下:
INSERT INTO publisher (publisher_id, publisher_name, contact, phone) 
VALUES 
('P001','Orielly','Ocean','02-1111111'),
('P002','McGraw','Don','02-22222222'),
('P003','Pearson','Mike','02-33333333'),
('P004','Apress','Allen','02-44444444');

Update更新資料

• Workbench用法：指定表格右鍵 > Select Rows > 修改完成後點擊Apply

################# 語法如下:
UPDATE tablename SET col1=value1, col2=value2 WHERE condition;

################# 範例如下:
UPDATE publisher 
SET contact='john' 
WHERE publisher_id='P001';

Delete刪除資料

• Workbench用法：指定表格右鍵 > View/Edit Data > All Rows > 點選欲刪除料列後點擊DELETE按鈕

################# 語法如下:
DELETE FROM table WHERE condition;

################# 範例如下:
DELETE FROM publisher 
WHERE publisher_id='P001';