MySQL 5.1 with Maria Reference Manual :: 12 SQL Statement Syntax :: 12.8 MySQL Compound-Statement Syntax :: 12.8.5 Cursors :: 12.8.5.1 DECLARE for Cursors
Section Navigation [Toggle]
- 12.8.5 Cursors
- 12.8.5.1 DECLARE for Cursors
- 12.8.5.2 Cursor OPEN Statement
- 12.8.5.3 Cursor FETCH Statement
- 12.8.5.4 Cursor CLOSE Statement
DECLAREcursor_nameCURSOR FORselect_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.
User Comments
Add your own comment.