Recommended Servers for MySQLThe world's most popular open source database
- Documentation Library
- Table of Contents
- MySQL 5.4 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 5.1 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”.
© 1995-2008 MySQL AB, 2008-2009 Sun Microsystems, Inc.
User Comments
Add your own comment.