MySQL 5.1 with Maria Reference Manual :: 12 SQL Statement Syntax :: 12.7 SQL Syntax for Prepared Statements :: 12.7.3 DEALLOCATE PREPARE Syntax
Section Navigation [Toggle]
- 12.7 SQL Syntax for Prepared Statements
- 12.7.1 PREPARE Syntax
- 12.7.2 EXECUTE Syntax
- 12.7.3 DEALLOCATE PREPARE Syntax
- 12.7.4 Automatic Prepared Statement Repreparation
{DEALLOCATE | DROP} PREPARE stmt_name
To deallocate a prepared statement produced with
PREPARE, use a
DEALLOCATE PREPARE statement that
refers to the prepared statement name. Attempting to execute a
prepared statement after deallocating it results in an error.
For examples, see Section 12.7, “SQL Syntax for Prepared Statements”.
User Comments
Add your own comment.