Syntax
------ 
FETCH cursor_name INTO var_name [, var_name] ...
 
Description
----------- 
This statement fetches the next row (if a row exists) using
the
specified open cursor, and advances the cursor pointer.
 
var_name can be a local variable, but not a user-defined
variable.
 
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).
 
See Cursor Overview for an example.
 


URL: https://mariadb.com/kb/en/fetch/