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:

Remove last two characters from given string

06-03-2017 substring javascript remove

How to find Angular Errors

06-03-2017 errors angularjs exceptionHandler

Filter for replace text in Angular Js

05-03-2017 filter replace angular js

How to set or update or push the values into Object in javacript

27-02-2017 javascript set update push object

Get Unique values from array/object in javascript

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