Hi everyone,
I need to pass a list of INT into a parameter of a stored procedure which should look like this:
UPDATE table01
SET updatedDate = now()
WHERE ID in (list of ids that I will pass in);
However the parameter type only accept INT, not list of INT, so not sure how can I achieve that.
Any suggestion will be much appreciated :)
Discussion posts and replies are publicly visible
Execute store procedure will not allow multiple values as input, but to achieve this change type to string and pass the value by Joining the array using joinarray() function and in the store proc use this code code like below sample,FIND_IN_SET(yourDBField,(REPLACE(JoinarrayString, '|', ','))) > 0
Why do you need a stored procedure for this simple task?