INSERT INTO Statement

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

Syntax

Way 1: Specify both column names and values

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

Way 2: Insert values for all columns (order matters!)

INSERT INTO table_name
VALUES (value1, value2, value3);

Insert Multiple Rows

You can insert multiple rows in a single statement:

INSERT INTO Customers (CustomerName, City, Country)
VALUES 
('Cardinal', 'Stavanger', 'Norway'),
('Wilman Kala', 'Helsinki', 'Finland');