Blog

INSERT INTO statement is used to insert a new row in a table of database. There are two ways to insert rows into a table

In the first way you do not specify the column names:

INSERT INTO My-Table
VALUES (value_1, value_2, value_3,...)

In the second way specifies both the column names and the values:

INSERT INTO My-Table (column_1, column_2, column_3,...)
VALUES (value_1, value_2, value_3,...)