This tutorial explains how to use the OPEN statement to open a cursor in MySQL with syntax and examples.
Once you've declared your cursor in MySQL, the next step is to use the OPEN statement to open the cursor.
The syntax to open a cursor using the OPEN statement in MySQL is:
The name of the cursor that you wish to open.
For example, you could open a cursor called c1 in MySQL with the following command:
Below is a function that demonstrates how to open a cursor.
CREATE FUNCTION FindSiteID ( name_in VARCHAR(50) )
DECLARE done INT DEFAULT FALSE;
DECLARE siteID INT DEFAULT 0;
DECLARE c1 CURSOR FOR
WHERE site_name = name_in;
DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;
FETCH c1 INTO siteID;
Copyright 2020. All Rights Reserved