Syntax:
DECLARE cursor_name CURSOR FOR select_statement

This statement declares a cursor. Multiple cursors may be declared in a
stored program, 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-cursor.html

