insert : insert is use for insert data into tables.
INSERT INTO customers (C_Id, Name, City, Address, Phone) VALUES (3, 'lucas', 'taipei', 'street', '07-12345678');
update : If we want to change the data in our tables we use update.
UPDATE customers SET Phone='03-87654321' WHERE Name='lucas';
merge
stored procedure
function
trigger
having
group by