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:

Functions in javascript

25-05-2018 functions javascript es5 es6 arrow functions named functions Closures Nested Functions Callbacks Arrow functions.

Time Sorting Ascending or Descending Order in Javascript

19-07-2017 Javascript ascending order descending order

Example for Conditional Operator in php

16-04-2017 php Conditional Operator example

How to insert bulk information into database in single query execution

18-03-2017 insert sql bulk database

Using slice remove last two characters from given string

07-03-2017 slice remove