17.5. Deallocating Prepared Statements

Prepared statements are dropped automatically when they are redefined or when you close the connection to the server, so there is rarely any reason to drop them explicitly. However, should you wish to do so (for example, to free memory on the server side), use the DEALLOCATE PREPARE statement:

 mysql> DEALLOCATE PREPARE namepop; Query OK, 0 rows affected (0.00 sec) 

MySQL also provides DROP PREPARE as an alias for DEALLOCATE PREPARE.