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:

Convert and download html to pdf without saving file

28-10-2018 node js convert html to pdf pdf download pdf without saving

How to use request module in node js

16-03-2017 request module node js

How to convert html to pdf in Node js

12-03-2017 pdf convert html node js

Email validation regular expression in javascript

22-02-2017 email validation regex

Get random strings from given string In javascript

21-02-2017 javascript random string