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 search text in string using php ?

29-10-2017 php search string search

How to submit form using javascript or jquery.

16-04-2017 javascript jquery submit form

Sanitization in java sript

14-03-2017 sanitization java script

Convert Time 24 hrs to 12 hrs format In javascript

12-03-2017 date javascript 12hrs convert

Get Unique values from array/object in javascript

19-02-2017 javascript unique remove repeated values from array