Learn SQL
Inserting data in tables
51.5
Lesson

Inserting multiple records

Let’s say we want to add information about multiple students. We can add these records through multiple INSERT INTO statements.

But, a single INSERT INTO statement can also be used to insert multiple records in a table. Look at the statement below.

The above SQL statement inserts 3 new rows of records in the table at once. The syntax is very similar to the one where we insert a single row of record. Each new set of records are enclosed in parentheses, and the individual rows, separated by a comma.