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. :)

Try phrasing this as a question ;)

Alex Deem
– Alex Deem

2009-11-11 12:59:56 +00:00
Commented Nov 11, 2009 at 12:59 — Alex Deem
– Alex Deem, Commented Nov 11, 2009 at 12:59

RC. · Accepted Answer · 2009-11-11 13:36:26Z

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.

edited Nov 11, 2009 at 13:36

answered Nov 11, 2009 at 13:00

RC.

28.5k10 gold badges80 silver badges94 bronze badges

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

1 Comment

ParisNakitaKejser Over a year ago

Tanks i think its make my problem out :) can you make a sample if i use 2 on each time? :) and tanks for the link.

Collectives™ on Stack Overflow

While select in mysql stored procuder

e.g.

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

e.g.

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related