CLOSE Statement

This MariaDB tutorial explains how to use the CLOSE statement to close a cursor in MariaDB with syntax and examples.

Description

The final step in MariaDB is to close the cursor once you have finished using it.

Syntax

The syntax to close a cursor in MariaDB is:

CLOSE cursor_name;

Parameters or Arguments

cursor_name

The name of the cursor that you wish to close.

Example

Let's look at how to close a cursor in MariaDB using the CLOSE statement.

For example:

CLOSE c1;

This CLOSE statement example would close the cursor called c1 in MariaDB.

Below is a function that demonstrates how to use the CLOSE statement:

DELIMITER //

 

CREATE FUNCTION FindSize ( name_in VARCHAR(50) )

RETURNS INT READS SQL DATA

 

BEGIN

 

   DECLARE done INT DEFAULT FALSE;

   DECLARE TotalSize INT DEFAULT 0;

 

   DECLARE c1 CURSOR FOR

     SELECT SUM(file_size)

     FROM pages

     WHERE site_name = name_in;

 

   DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

 

   OPEN c1;

   FETCH c1 INTO TotalSize;

 

   CLOSE c1;

 

   RETURN TotalSize;

 

END; //

 

DELIMITER ;