Updated on 2024-09-02 GMT+08:00

DEALLOCATE

Function

Deallocates a previously prepared statement. If a prepared statement is not explicitly deleted, it is deleted at the end of the session.

For details about prepared statements, see PREPARE.

Precautions

None

Syntax

1
DEALLOCATE [ PREPARE ] { name | ALL };

Parameter Description

  • PREPARE

    This keyword is optional and is often ignored.

  • name

    Specifies the name of the prepared statement to deallocate.

  • ALL

    Deallocates all prepared statements.

Examples

None