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:
Compare the Triplets | Javascript | hackerrank.com07-05-2020 hackerrank.com |
Check null values in JavaScript?04-02-2019 JavaScript null check null value |
Detect AdBlock with JavaScript in my browser30-07-2017 AdBlock javascript detect |
How to change background color and color to the text using javascript27-02-2017 css javascript colors |
How to remove last / value from url in javascript27-02-2017 array javascript last value |