SQL的insert, delete 和 update

Insert

正常版本
INSERT INTO table_name (column1, column2, column3,···)
VALUES (value1, value2, value3,···);

簡化版本(但每一欄位必填)
INSERT INTO table_name
VALUES (value1, value2, value3,···);

僅輸入特定欄位
INSERT INTO customers (C_Id, Name, City)
VALUES (3, '李三', '高雄縣');

多筆輸入
INSERT INTO table_name
VALUES (value1, value2, value3,···),
(value2_1, value2_2, value2_3,···),
(value3_1, value3_2, value3_3,···),
······;

從其他table輸入資料
INSERT INTO table_name (column1, column2, column3,···)
SELECT othercolumn1, othercolumn2, othercolumn3,···
FROM othertable_name;

refrence: http://webdesign.kerthis.com/sql/sql_insert


------------------------------------------------------------

Delete
正常版本
DELETE FROM customers
WHERE Name='王二';

註：一定要加where，不然會整個資料表的資料會全清空

reference: http://webdesign.kerthis.com/sql/sql_delete


------------------------------------------------------------


Update
正常版本
UPDATE customers
SET Phone='03-87654321'
WHERE Name='王二';

註：一定要加where，不然會整個資料表的資料都會被更新

reference: http://webdesign.kerthis.com/sql/sql_update