Sql Insert Multiple Rows — Free Sql Tutorial

TL;DR: Learn Sql Insert Multiple Rows in Sql with a free, beginner-friendly tutorial, examples and practice for Indian students on Syllab.in.

Sql Insert Multiple Rows in Sql

INSERT INTO ... VALUES can insert a single row or multiple rows at once. Multiple-row INSERT is much faster than running INSERT separately for each row.

Syntax: INSERT INTO table (col1, col2) VALUES (val1, val2), (val3, val4), (val5, val6);

This is the most efficient way to bulk-load data. In real apps, use LOAD DATA INFILE (MySQL) or COPY (PostgreSQL) for very large datasets.

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

-- Multiple rows
INSERT INTO table (col1, col2) VALUES
  (val1, val2),
  (val3, val4),
  (val5, val6);

Learn Sql Insert Multiple Rows step by step with Syllab's free interactive Sql tutorial — runnable code examples, practice exercises and instant AI feedback, all free with no signup. Explore the full Sql course →