W3cubDocs

/MariaDB

Cursors

A cursor is a structure that allows you to go over records sequentially, and perform processing based on the result.

Title Description
Cursor Overview Structure for traversing and processing results sequentially.
DECLARE CURSOR Declares a cursor which can be used inside stored programs.
OPEN Open a previously declared cursor.
FETCH Fetch a row from a cursor.
CLOSE Close a previously opened cursor.
Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/programmatic-compound-statements-cursors/