SQL Insert Into – Tech Snippets

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 Table1SET Column1 = Value1,*Column2 = Value2WHERE Column_Name = Value*i.e.*UPDATE EmployeeSETContinue reading “SQL Command – insert Into, Delete, Update”