How to insert bulk information into database in single query execution

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 use http-post request in node js

14-03-2017 http-post module node js

Get previous date from given date in javascript

06-03-2017 date javascript previous date

Filter for replace text in Angular Js

05-03-2017 filter replace angular js

Call a function every second or 5 seconds in javascript

22-02-2017 setinterval function calling

Send Mail in Node Js

21-02-2017 node js mail npm module