How to insert multiple rows in SQL ?

DBMSMySQLSQL

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

     

Advertisements

ads