Looping through array in mysql stored procedure

Question

I want to use arrays in mysql stored procedures.

i.e. array would look like

(0 =>array('name','value','value1'), 1=> array('name1','value2','value3))

I want to loop through each of them and perform some action on different tables. Can i do this ?

Kneel-Before-ZOD · Accepted Answer · 2012-11-20 06:31:30Z

3

Stored Procedures do not accept arrays; you can, however, send as many input values as you want, as long as it matches the number and types of parameters declared in the stored procedure.

Hope this helps.

answered Nov 20, 2012 at 6:31

Kneel-Before-ZOD

4,2031 gold badge26 silver badges27 bronze badges

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

Comments

Devart · Accepted Answer · 2012-11-20 07:06:48Z

1

If you want to pass more then one item, then use additional (temporary) table instead of IN parameters.
If you need to pass items one by one - ('name','value','value1'), then use some IN parameters - (IN name VARCHAR(255), IN value1 INT(11), IN value2 INT(11))

answered Nov 20, 2012 at 7:06

Devart

120k23 gold badges172 silver badges189 bronze badges

Collectives™ on Stack Overflow

Looping through array in mysql stored procedure

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related