INSERT INTO

INSERT INTO statement is used to insert values or records into table in SQL.

Records in a table can be added by specifying both the column names and their values that need to be updated.

Syntax-

INSERT INTO <table_name>(column1, column2, column3, …)

VALUES (value1, value2, value3, …);

Records in a table can also be added without specifying column names, if you are adding values for all the columns of the table in the same order as the columns in the table.

Syntax-

INSERT INTO <table_name>

VALUES (value1, value2, value3, …);