https://www.techonthenet.com/mysql/cursors/declare.php


MySQL: Declare a Cursor

This MySQL tutorial explains how to declare a cursor in MySQL with syntax and examples.


Description

A cursor is a SELECT statement that is defined within the declaration section of your stored program in MySQL.


Syntax

The syntax to declare a cursor in MySQL is:


DECLARE cursor_name CURSOR FOR

  select_statement;

Parameters or Arguments

cursor_name

The name to assign to the cursor.

select_statement

The SELECT statement associated with the cursor.

Example

Let's look at how to declare a cursor in MySQL.


For example:


DECLARE c1 CURSOR FOR

  SELECT site_id

  FROM sites

  WHERE site_name = name_in;

The result set of this cursor is all site_id values where the site_name matches the name_in variable.


Below is a function that uses this cursor.


DELIMITER //