Syntax:
{DEALLOCATE | DROP} PREPARE stmt_name

To deallocate a prepared statement, use the DEALLOCATE PREPARE
statement. Attempting to execute a prepared statement after
deallocating it results in an error.

URL: http://dev.mysql.com/doc/refman/5.0/en/sql-syntax-prepared-statements.html

