Inserting data in tables

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.