MySQL Stored Procedure Pass Array of Ids into it

johnCash · September 17, 2007, 4:53pm

I need to pass Array of Ids into it MySQL Stored Procedure, is this possible? I am running mysql 5.1.20.

r937 · September 17, 2007, 5:13pm

yes, pass them in as a VARCHAR of comma-delimited values

johnCash · September 17, 2007, 6:15pm

I need to create a temp table and put the comma delimited values into that table.

If lot of people are calling the procedrue split_string, does it mean
only one will be executed at a time and rest of the request will be dropped?

would split_string will forked to create many process to handle the request?

r937 · September 17, 2007, 6:35pm

why do you need to create a temp table?

johnCash · September 17, 2007, 7:49pm

I guess you don’t need temp table, pass a big string with comma delimited as varchar.