How to insert bulk information into database in single query execution

18-03-2017 insert sql bulk database

Basically the basic inserting query in sql is 

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3);

but i need to insert n number of rows in a single query execution. like below 

INSERT INTO tbl_name (a,b,c) VALUES(1,2,3),(4,5,6),(7,8,9);

or 

INSERT INTO tbl_name VALUES (1,2), (5,5);

 

 

You might also like:

How to convert html to pdf in Node js
12-03-2017 pdf convert html node js
Filter for change Date format (MM-dd-yyyy HH:mm) in Angular Js
05-03-2017 mm-dd-yyyy HH:MM date formats angular js
How to get drop down value when drop down change using javascript
27-02-2017 onchange events dropdown javascript functions
Call a function every second or 5 seconds in javascript
22-02-2017 setinterval function calling
Get Unique values from array/object in javascript
19-02-2017 javascript unique remove repeated values from array