INSERT INTO
INSERT INTO 表格名稱 (欄位1,欄位2,欄位3) VALUES ('vlaue1', 'value2', 'value3') 例如INSERT INTO user (id, name, age) VALUES ('', 'hhhhhhhhllllllllllff', '20') |
UPDATE
UPDATE 表格名稱 SET 欄位='value' WHERE 欄位='條件'
例如UPDATE user SET age='21' WHERE id='1';
DELETE
DELETE FROM 表格名稱 WHERE where_definition;