INSERT INTO

INSERT INTO adds new rows. Specify columns and values.

Bulk Insert

Multiple rows in one statement for better performance.

Syntax

MYSQL

1
2
3
4

INSERT INTO users (name, email, age) VALUES ("Alice", "alice@mail.com", 25);
INSERT INTO users (name, email, age) VALUES
    ("Bob", "bob@mail.com", 30),
    ("Charlie", "charlie@mail.com", 28);

INSERT Records

SQL

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

INSERT INTO users (name, email, age, city)
VALUES ("Alice", "alice@example.com", 25, "Lahore");

-- Multiple rows
INSERT INTO users (name, email, age, city) VALUES
("Bob", "bob@example.com", 30, "Karachi"),
("Eve", "eve@example.com", 22, "Islamabad");

-- INSERT ... SELECT
INSERT INTO admins (name, email)
SELECT name, email FROM users
WHERE age >= 30;

-- Verify
SELECT * FROM users;

Try It Yourself

Practice

1

Exercise

Insert a new user Eve, eve@test.com, age 22.

Answer

INSERT INTO users (name, email, age) VALUES ("Eve", "eve@test.com", 22);

Quick Quiz

1

What if a nullable column is omitted in INSERT?

Error

NULL is inserted

Default value

Row rejected

NULL is inserted if the column allows it.

Retry Quiz

Interview Questions

Benefits of bulk INSERT?

Reduces round-trips, minimizes transaction overhead, significantly faster for large datasets.

Next Lesson

UPDATE & DELETE