How to assign a set of value in mysql stored procedure

Asked Aug 01 '17 at 00:53

Active Aug 01 '17 at 01:31

Viewed 32 times

I want to do such a job: In MySQL statement, try to assign a set of values (1, 6, 68, 76, 43) in this order to a variable a. That is: in a lop, first, a=1 do the loop then a=6 do the loop then a=68 do the loop and so on.

Can anyone show me how to do it? Thanks

edited Aug 01 '17 at 01:02

Shadow

33,525
10
51
64

asked Aug 01 '17 at 00:53

Lawrance Zhang

Is this list likely to change? – Shadow Aug 01 '17 at 01:07
No, will be a hard coded list – Lawrance Zhang Aug 01 '17 at 01:12
The linked duplicate topic explains how to process a list of values provided in a single string where the values are separated by comma. Just use the same logic with a hard coded string of your values. – Shadow Aug 01 '17 at 01:38

How to assign a set of value in mysql stored procedure

0 Answers0