Movatterモバイル変換

{DEALLOCATE | DROP} PREPAREstmt_name

To deallocate a prepared statement produced withPREPARE, use aDEALLOCATE PREPARE statement that refers to the prepared statement name. Attempting to execute a prepared statement after deallocating it results in an error. If too many prepared statements are created and not deallocated by either theDEALLOCATE PREPARE statement or the end of the session, you might encounter the upper limit enforced by themax_prepared_stmt_count system variable.

For examples, seeSection 15.5, “Prepared Statements”.