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;