SQL INSERT INTO Statement

Used to insert new records in a table
INSERT INTO Customers (CustomerName, ContactName, City, Country)
VALUES ('Hardcode Systems', "Micheal Gruber', 'Berlin', 'Germany');
A new record inserted to the Customers table.

SQL INSERT INTO Statement

Used to insert new records in a table
UPDATE Customers SET ContactName='Tania Hesse', City='Frankfurt' WHERE CustomerName='Hardcode Systems';
The ContactName and City of Hardcode Systems record in the Customers table are Updated.

SQL DELETE Statement

Used to delete one or more records in a table
DELETE FROM Customers WHERE CustomerName='Hardcode Systems'; Hardcode Systems record deleted.

DELETE * FROM Customers'; delete all records