How to insert multiple rows in MySql DB using My SQL Connector.

Submitted by akhilesh.pathak on Thu, 04/10/2014 - 16:33

In MySql connector, how we can insert multiple rows ? Because the insert statement allows one row at a time ?

1 answer

Submitted by matthieu.chaffotte on Tue, 04/22/2014 - 13:22

Hi,

It is possible to add several rows using the INSERT Statement in MySQL.

Example: INSERT INTO myTable (a, b, c) VALUES (1, 2, 3), (1, 4, 8) , ...;

Regards