Syntax:
DECLARE cursor_name CURSOR FOR select_statement

This statement declares a cursor. Multiple cursors may be declared in a
routine, but each cursor in a given block must have a unique name.

The SELECT statement cannot have an INTO clause.

URL: http://dev.mysql.com/doc/refman/5.0/en/declare-cursors.html

