SQL INSERT

SQL INSERT

INSERT Command used to insert/add records into a table.

Syntax:

INSERT INTO Table1
VALUES (value1, value2, value3…)

or

INSERT INTO Table1 (Column1, Column2, Column3…)
VALUES (Value1, Value2, Value3…)

Also data can be inserted by using a SELECT and INSERT combination.

INSERT INTO table1 SELECT * FROM table2

186 views

Return to top