INSERT Statement Syntax
INSERT statement is used to add new rows to table.
Syntax of INSERT statement below :
Only one row can be inserted at a time with this syntax.
INSERT statement can also be used for copying rows from another table.
Syntax below :
INSERT INTO table1 ( column11 , column12 , ….. )
SELECT column21 , column22 , …….
FROM
table2
Example below :