Re: set multiple element from select in procedure stored

[Xavier Manach]

Mysql best solution :)
declare a smallint;
declare b smallint;
select col_a, col_b from my_table where col_c=1 INTO a,b;