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

Basic Syntax

INSERT INTO person (person_id, first_name, last_name)
VALUES (1, 'John', 'Doe');

Insert a new person with ID 1.

Inserting Multiple Rows

Multiple rows can be inserted at once:

INSERT INTO person (person_id, first_name, last_name)
VALUES 
    (2, 'Jane', 'Smith'),
    (3, 'Bob', 'Johnson');

Insert multiple records in a single statement.