How to insert multiple rows in SQL ?

To insert multiple rows in SQL we can follow the below syntax:


INSERT INTO table_name (column1, column2,column3...)
VALUES
    (value1, value2, value3…..),
    (value1, value2, value3….),
    ...
    (value1, value2, value3);

We start off by giving the keywords INSERT INTO then we give the name of the table into which we would want to insert the values. We will follow it up with the list of the columns, for which we would have to add the values. Then we will give in the VALUES keyword and finally, we will give the list of values.

Here is an example of the same:


INSERT INTO employees (
    name,
    age,
    salary)
VALUES
    (
        'Sam',
        21,
       75000
    ),
    (
        ' 'Matt',
        32,
       85000    ),

    (
        'Bob',
        26,
       90000
    );

In the above example, we are inserting multiple records into the table called employees

How to insert multiple rows in SQL ?

Published on 16-Dec-2021 16:49:13

You may also like this!