DEALLOCATE PREPARE

Description

This statement is used to deallocate a prepared statement.

Syntax

{DEALLOCATE | DROP} PREPARE stmt_name

Parameters

Parameter	Description
stmt_name	The name of the prepared statement.

Examples

Deallocate the prepared statement.

PREPARE stmt1 FROM 'PURGE RECYCLEBIN';
Query OK, 0 rows affected

DROP PREPARE stmt1;
Query OK, 0 rows affected