Insert Multiple SQL Rows: Quick Guide

1 year ago
Emily Johnson
1 minute

To add multiple rows of data to a SQL database at once, you can use the INSERT INTO statement with a VALUES clause. Here is an example:

INSERT INTO table_name (column1, column2, column3)
VALUES (value1, value2, value3),
       (value4, value5, value6),
       (value7, value8, value9);

In the example above, table_name is the name of the table where data will be inserted, column1, column2, column3 are the column names in the table, and value1, value2, value3, etc. are the specific values to be inserted. By specifying multiple values in the VALUES clause, you can add multiple rows of data to the table at once.

bannerAds