SQL · Chapter 7 of 42

SQL INSERT INTO

INSERT adds new rows to a table. You can list columns explicitly or rely on the table's column order.

Best practice: always list columns.

Syntax

INSERT INTO table (col1, col2) VALUES (val1, val2);

Single & multiple rows

One VALUES clause per row; separate with commas to insert many rows in a single statement.

Copy rows from another query: `INSERT INTO t (a) SELECT a FROM other;`

Example 1 (sql)

INSERT INTO users (name, age, country)
VALUES ('Ana', 25, 'India');

Output

1 row inserted

Add a single row.

Example 2 (sql)

INSERT INTO products (name, price) VALUES
('Book', 250),
('Pen', 20),
('Bag', 900);

Output

3 rows inserted

Bulk insert.

💡 Note: Missing columns default to NULL (or the column's DEFAULT value). Required NOT NULL columns must be included.