5.6

FETCH

Fetch rows from a cursor.

Synopsis

FETCH [ direction [ FROM | IN ] ] cursor_name

Where direction can be empty or one of:

NEXT RELATIVE count ABSOLUTE position count ALL FORWARD FORWARD count FORWARD ALL

Description

Fetches rows from a cursor created using DECLARE.

A cursor has a position and each time you use FETCH, the position changes and the rows spanning the position change get returned.

Parameters

direction

NEXT

Fetch the next row. This is the default

RELATIVE count

Fetch count rows relative to the current position.

ABSOLUTE position

Jumps to the position and returns the row, or an empty result if jumped to a position outside the result set.

Jumping backward is only possible if the cursor was created with SCROLL set in DECLARE.

count

Fetch the next count rows

ALL

Fetch all remaining rows

FORWARD

Same as NEXT

FORWARD count

Same as count

FORWARD ALL

Same as ALL

BACKWARD

Move 1 row back

Moving backward is only possible if the cursor was created with SCROLL set in DECLARE.

BACKWARD count

Move count rows back

Moving backward is only possible if the cursor was created with SCROLL set in DECLARE.

count

A integer constant, determining which or how many rows to fetch

cursor_name

Name of the cursor to fetch rows from.