Insert Multiple records in nodejs in single Query

Question

I am inserting dynamic records

var sql = "INSERT INTO Test (name, email, n) VALUES ?";
var values = [
    ['test', '[email protected]', 1],
    ['test', '[email protected]', 2],
    ['mark', '[email protected]', 3],
    ['pete', '[email protected]', 4]
];
conn.query(sql, [values], function(err) {
    if (err) throw err;
    conn.end();
});

here is example which is working fine

Now my data is here

var arr = category_ids.split(",");
for (var i = 0; i < arr.length; i++) {

}

How to make dynamic array of values in for loop

Thanks

Community · Accepted Answer · 2020-06-20 09:12:55Z

2

You just need an array of arrays, like what values is in the example you provided.

Your example

var arr = category_ids.split(",");
var values = [ arr ];

or simply

var value = [ category_ids.split(",") ];

edited Jun 20, 2020 at 9:12

CommunityBot

11 silver badge

answered Nov 19, 2014 at 9:39

Nabil Kadimi

10.5k2 gold badges56 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Hitu Bansal Over a year ago

How to create an array for that

Collectives™ on Stack Overflow

Insert Multiple records in nodejs in single Query

1 Answer 1

Your example

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Your example

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related