SQL Insert command is used to insert data into tables. Insert command will insert data in the shape of rows into our table.
SYNTAX:
INSERT INTO tablename (column1, column2, column3) VALUES (‘value1’, ‘value2’, ‘value3’)
EXAMPLE:
INSERT INTO ITEMS_SHAHID4
(ItemName, ItemPrice, ItemCat, ItemDesc)
VALUES
(‘projector’, ‘300’, ‘computers’, ‘I m selling a sony projector. Please please please buy it.’)
DESCRIPTION:
fOR INSERTING DATA INTO TABLES. If a value to be inserted is for a character or datetime data type, it must be enclosed within single quotes. Numbers do not require single quotation.
Example of Insert Command for Ms Sql Server
Insert into Product values
(
'Epson 2K',
'Printer',
100,
'Enjoy from colour printing'
)
Copy Data from one table into another table
To copy data between two tables of the same structure use the following statement:
Insert into TableB (field1, field2) select field1, field2 from TableA