how can fetch record from query with out using cursor if we have multiple records

Question

how can fetch record from query with out using cursor if we have multiple results are there can we do this like the following code

FOR r IN (SELECT a,b,c FROM tabel WHERE a=1) LOOP SHOW (r.a); END LOOP; i want to do this with cursor because this condition happen inside another cursor is it possible to do this with our cursor or declare new cursor inside existing cursor?

araknoid · Accepted Answer · 2013-02-23 11:58:21Z

1

You can/should do it with two cursor and in particular you can nest a second cursor inside the first one.

In particular, give a look to this article about "Neting MySQL Cursor Loops" http://rpbouman.blogspot.it/2005/10/nesting-mysql-cursor-loops.html

It gives you plenty points of view of how you can solve your problem.

answered Feb 23, 2013 at 11:58

araknoid

3,1235 gold badges36 silver badges37 bronze badges

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

Collectives™ on Stack Overflow

how can fetch record from query with out using cursor if we have multiple records

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