using variables in my mysql stored procedure

Question

In my stored procedure I need to use some variable names as foo1, foo2, foo3 .... foo10 This is not a problem, on the declaration stage, but in the logic stage, doing the calculus this is a real pain.

For example, how can I do: bar[i] = ( foo[i] + foo10 ) / foo[i];

PS: if there is not any way of using arrays, can I use concaternation, in order to get:
foo1 = 'foo' + '1'? Adain, foo1 is a variable name;

jmoreno · Accepted Answer · 2011-10-18 06:14:15Z

1

SQL does not have arrays, it has tables which are sets. If you give a concrete example of what you want to do, someone might be able to help you, but for the moment you're barking up the wrong tree.

answered Oct 18, 2011 at 6:14

jmoreno

13.7k6 gold badges66 silver badges103 bronze badges

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

Collectives™ on Stack Overflow

using variables in my mysql stored procedure

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related