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:

Simple Array Sum | Javascript | hackerrank.com

07-05-2020 hackerrank.com javascript arrays array sum

Compare the Triplets | Javascript | hackerrank.com

07-05-2020 hackerrank.com

File Upload Using Angular Js and Node Js

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

Detect AdBlock with JavaScript in my browser

30-07-2017 AdBlock javascript detect

Filter for change Date Time format (MM-dd-yyyy HH:mm) in Angular Js

05-03-2017 mm-dd-yyyy HH:MM date formats angular js