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 use http-post request in node js14-03-2017 http-post module node js |
Get previous date from given date in javascript06-03-2017 date javascript previous date |
Filter for replace text in Angular Js05-03-2017 filter replace angular js |
Call a function every second or 5 seconds in javascript22-02-2017 setinterval function calling |
Send Mail in Node Js21-02-2017 node js mail npm module |