How to insert bulk information into database in single query execution


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);


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



You might also like:

File Upload Using Angular Js and Node Js

28-05-2018 AngularJs Node js file upload multer module

How to upload file by using request module

18-03-2017 request module node js

Convert Time 24 hrs to 12 hrs format In javascript

12-03-2017 date javascript 12hrs convert

Navigate to another page using java script

06-03-2017 javascript redirection navigation

Filter for insert HTML in Angular Js

06-03-2017 filter show html angular js html