Cursor programs | Sololearn: Learn to code for FREE!

0

Cursor programs

sql

3/8/2017 5:42:53 PM

niranjan doephode

1 Answer

New Answer

+1

https://dev.mysql.com/doc/refman/5.7/en/cursors.html You normally declare a cursor for a select, then you open it, then define a loop. Inside the loop, you iterate (fetch) over every return that is returned by the select, until no more records are left, moment in which you leave the loop. Finally, you close the cursor.