MariaDB: 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 ;