MySQL 5.5 Reference Manual :: 12 SQL Statement Syntax :: 12.7 MySQL Compound-Statement Syntax :: 12.7.5 Cursors :: 12.7.5.1 DECLARE for Cursors
Section Navigation [Toggle]
- 12.7.5 Cursors
- 12.7.5.1 DECLARE for Cursors
- 12.7.5.2 Cursor OPEN Statement
- 12.7.5.3 Cursor FETCH Statement
- 12.7.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.
For information available through
SHOW statements, it is possible
in many cases to obtain equivalent information by using a cursor
with an INFORMATION_SCHEMA table.
User Comments
Add your own comment.