Syntax:
CLOSE cursor_name

This statement closes a previously opened cursor.

If not closed explicitly, a cursor is closed at the end of the compound
statement in which it was declared.

URL: http://dev.mysql.com/doc/refman/5.1/en/close.html

