MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.7 MySQL Compound-Statement Syntax :: 12.7.5 Cursors :: 12.7.5.3 Cursor FETCH Statement
Section Navigation [Toggle]
- 12.7.5 Cursors
- 12.7.5.1 DECLARE for Cursors
- 12.7.5.2 Cursor OPEN Statement
- 12.7.5.3 Cursor FETCH Statement
- 12.7.5.4 Cursor CLOSE Statement
FETCHcursor_nameINTOvar_name[,var_name] ...
This statement fetches the next row (if a row exists) using the specified open cursor, and advances the cursor pointer.
If no more rows are available, a No Data condition occurs with
SQLSTATE value 02000. To detect this condition, you can set up a
handler for it (or for a NOT FOUND
condition). An example is shown in Section 12.7.5, “Cursors”.
User Comments
What about cursor functions, such as @@fetch_status and @@cursor_rows in T-SQL? I don't see any such functions mentioned anywhere, and they are crucial for using cursors.
Please look into DECLARE HANDLER. The NOT FOUND condition handles this particular situation.
Add your own comment.