Beginner

705. Insert Multiple Rows

Learn how to insert multiple records using a single INSERT INTO statement.

📘 Lesson 705 of 728 ⏱ 6 min 🎯 Beginner

SQL allows multiple rows to be inserted in one statement by separating each set of values with commas. This reduces database calls and improves performance.

Loading multiple records together is much faster than executing individual INSERT statements for every row.

An HR department receives details of three new employees and inserts them together using one SQL statement.

SQL 
INSERT INTO Employees
(
    EmployeeID,
    EmployeeName,
    Department,
    Salary
)
VALUES
(102,'Priya Shah','HR',52000),
(103,'Amit Kumar','Finance',61000),
(104,'Neha Patel','IT',72000);

Bulk employee imports, customer uploads, product catalogs, and daily transaction loading commonly use multiple-row INSERT statements.

  • Inserts multiple rows together.
  • Reduces database execution time.
  • Improves performance.
  • Each row must contain the same number of values.
  • Values must match column data types.
  • Useful for bulk data loading.
  • Supported by most modern databases.
Why insert multiple rows in one statement?

It improves performance by reducing multiple database calls.

Must every row contain the same number of values?

Yes. Every inserted row must match the specified columns.

Have you finished this lesson?

Introduction to SQL – All Lessons