SQL Command – insert Into, Delete, Update

Insert Into Command:Insert Into Command adds rows to an existing table.*

INSERT INTO <Table_Name>

(Column1, Column2, Column3…)

VALUES (Value1, Value2, Value3…)*i.e.

INSERT INTO Customers (FirstName, LastName, DOB, Phone)

VALUES (‘Peter’, ‘Jack’, ‘1/12/1974’, ‘444 888-8888’);

Update Command:Update Command modifies a set of existing table rows.

UPDATE Table1
SET Column1 = Value1,*Column2 = Value2
WHERE Column_Name = Value*i.e.*UPDATE Employee
SET DateOfJoining = ‘5/10/1974′
WHERE LastName = ‘Castilo’ AND FirstName = ‘Stance’

DELETE Command: DELETE Command removes existing rows from a table, e.g

DELETE FROM <Table_Name>
WHERE Column_Name = Value*i.e.*DELETE FROM Customers
WHERE LastName = ‘Smith’