Insert more than one records in mysql Table

Question

I am inserting records to MySQL Table using the following Query :

insert into table(field1, field2) values(1,2);

Now again when I want to add data I am using the above query only change data like :

insert into table(field1, field2) values(3,4);

So is there a way using which I can add more data at a time ?

possible duplicate of [Inserting multiple rows in mysql](http://stackoverflow.com/questions/6889065/inserting-multiple-rows-in-mysql) and http://dev.mysql.com/doc/refman/5.5/en/insert.html — feeela, Jun 02 '14 at 09:37
Although this question is duplicate, I feel that this question is better worded and the other question should instead be flagged as duplicate and point to this. — slebetman, Jun 02 '14 at 10:10

score 1 · Accepted Answer · answered Jun 02 '14 at 09:33

1

You can use following query :

INSERT INTO table(field1, field2) VALUES(1,2),(4,5),(7,8);

answered Jun 02 '14 at 09:33

user3145373 ツ

score 1 · Answer 2 · answered Jun 02 '14 at 09:33

Yes, you can just list all the tuples you want to insert in one query, like this:

INSERT INTO table (field1, field2) values (1, 2), (3, 4);

Or you can specify the inserted data by a subquery:

INSERT INTO table (field1, field2)
SELECT field3, field4 FROM table2
WHERE conditions;

score 1 · Answer 3 · answered Jun 02 '14 at 11:11

1

To insert more than one record at once, we can do this, with each set of field values separated by a comma:

 INSERT INTO table
 VALUES
 (field1, field2),
 (field1, field2),
 (field1, field2),
 (field1, field2)...;

answered Jun 02 '14 at 11:11

Sunil C K

score 0 · Answer 4 · answered Jun 02 '14 at 09:35

0

Try this,

INSERT INTO TABLE(field1, field2) VALUES(1,2),
                                        (3,4),
                                        ..... ;

answered Jun 02 '14 at 09:35

ravikumar

4 Answers4