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:
Sanitization in java sript14-03-2017 sanitization java script |
Convert Time 24 hrs to 12 hrs format In javascript12-03-2017 date javascript 12hrs convert |
Get previous date from given date in javascript06-03-2017 date javascript previous date |
How to find Angular Errors06-03-2017 errors angularjs exceptionHandler |
Filter for change Date format (MM-dd-yyyy) in Angular Js05-03-2017 mm-dd-yyyy date formats angular js |