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:
Simple Array Sum | Javascript | hackerrank.com07-05-2020 hackerrank.com javascript arrays array sum |
Check null values in JavaScript?04-02-2019 JavaScript null check null value |
File Upload Using Angular Js and Node Js28-05-2018 AngularJs Node js file upload multer module |
Filter for change Date Time format (MM-dd-yyyy HH:mm) in Angular Js05-03-2017 mm-dd-yyyy HH:MM date formats angular js |
Email validation regular expression in javascript22-02-2017 email validation regex |