INSERT query needed for multiple rows

Question

How would I make a query to INSERT repeating data into several rows in a database? I have an auto incremented field id so I feel a simple

INSERT INTO table_name (column, column) 
VALUES ('data', 'data')

should be fine but not sure how to make it do it multiple times.

I am using MySql. I've been using exactly the above query and, yes, expecting the addition of a rows with that information and the rest becomes NULL..which is what I want, but I want it to do that but more maybe the next 20 rows..I have looked at using INSERT ALL beforehand, but that gave me an syntax error. — Casey Stack, Jun 15 '15 at 19:07

score 0 · Answer 1 · answered Jun 15 '15 at 19:05

0

Notice how MYSQLDUMP does it. The VALUES clause allows a list of one-or-more value sets to be provided. A new row will be inserted for each.

answered Jun 15 '15 at 19:05

Mike Robinson

8,490
5
28
41

score 0 · Accepted Answer · edited May 23 '17 at 10:29

This is a fairly common question, so I imagine more searching would've been beneficial. That said, a common syntax would be like the below, depending on which RDBMS you are using.

INSERT INTO table_name (column1, column2) 
VALUES ('data', 'data'), ('data', 'data'), ('data', 'data')

See other examples here:

Inserting multiple records

3 methods to insert multiple records

There is also the notion of bulk inserting, but again, not much information about your environment.

INSERT query needed for multiple rows

2 Answers2