The SQL INSERT INTO Statement

The INSERT INTO statement is used to insert new records in a table.

Syntax

    INSERT INTO table_name (column1, column2, column3, ...)
    VALUES (value1, value2, value3, ...);

Output

The column parameters specify the names of the columns of the table.

The datatype parameter specifies the type of data the column can hold (e.g. varchar, integer, date, etc.).