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 upload file by using request module
18-03-2017 request module node js
How to use http-post request in node js
14-03-2017 http-post module node js
How to get current date and time (yyyy-mm-dd H:i:s) using javascript
09-03-2017 javascript date time
Get next date from given date in javascript
06-03-2017 date javascript next date
Filters for convert text to camel case in Angular Js
05-03-2017 angularjs camelcase filters