Currently I am working on my Web site Frontend: Vue Backend: Node.js
I am trying make a function which allows managers to delete user.
While making some SQL code for delete user information, I comes to my mind that
I cannot expect number of user deleted by manager..
It could be one, two or more.
So, please advice me how to tackle with this situation.
I want to finish this in a single SQL sentence.
Thank you very much.
I have tried to make SQL codes like this
DELETE FROM user_table WHERE user_id = ${1} AND ${2} AND ${3} or more…..
I want to know a condition use for unexpected number of user Input
>Solution :
use IN
let user_ids_to_delete = req.body.user_ids; //example : [1,2,3,4]
let query = `DELETE FROM user_table WHERE user_id IN(${user_ids_to_delete});`