MySQL 5.1 Reference Manual :: 12 SQL Statement Syntax :: 12.6 SQL Syntax for Prepared Statements :: 12.6.3 DEALLOCATE PREPARE Syntax
Section Navigation [Toggle]
- 12.6 SQL Syntax for Prepared Statements
- 12.6.1 PREPARE Syntax
- 12.6.2 EXECUTE Syntax
- 12.6.3 DEALLOCATE PREPARE Syntax
- 12.6.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.6, “SQL Syntax for Prepared Statements”.
User Comments
Add your own comment.