Delete bulk record from MySql table while passing array in nodejs [duplicate]

Question

I want to pass as array of id's and with this array i want to delete multiple records from table in node js

Below code which i was trying but it's not working properly;

let deletedImageIds = [24081,222];

db.query(`delete from mx_product_images where productImageID in ?`, deletedImageIds, (err, res) => {
                  if (err) {
                    console.log("error: ", err);
                    callback(err, null); 
                    return;
                  }
                  callback(null, res);
                  return;
                })

jithu thomas · Accepted Answer · 2020-05-05 17:06:03Z

1

This is because MySQL can't understand javascript array/objects. so please convert this javascript array to a comma-separated string, then append to the original query.

let deletedImageIds = [24081,222];
let del_str = deletedImageIds.join();

db.query(`delete from mx_product_images where productImageID in (?)`, del_str, (err, res) => {
                  if (err) {
                    console.log("error: ", err);
                    callback(err, null); 
                    return;
                  }
                  callback(null, res);
                  return;
                })

answered May 5, 2020 at 17:06

jithu thomas

2991 silver badge3 bronze badges

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

Collectives™ on Stack Overflow

Delete bulk record from MySql table while passing array in nodejs [duplicate]

1 Answer 1

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Linked

Related