While select in mysql stored procuder

Question

i will try a select into my Stored Procedure like a while

e.g.

while ( select * from t where t.c = 1 into test_t )
{
    var_t_e = test_t.c;
}

i hope i can be helped here. :)

Answer 1

Look at this documentation on using cursors in your stored procedure.

Edit based on comment:

I'm not quite sure what you're asking for based on your comment. If you can clarify I can try and give you a more specific example. Here is a link that goes through the steps of producing a stored procedure with a cursor with some good information on the individual steps and also when you shouldn't use a cursor. This may be more helpful for you.