About whether MySQL uses deallocate after using the Prepare Keyword precompiled statement

is a database in the MySQL database with a user table.

1. After creating a new query, use prepare to pre-compile the query results (Note: Use the DEALLOCATE keyword to delete the precompiled statement)

2. Run the pre-compiled statement AA just again,

There was an error in the result. The reason is that precompiled statements have been removed before using deallocate.

3. This time do not use the DEALLOCATE keyword to delete the precompiled statement.

Once again, call a pre-compiled AA statement.

You can still use the statement this time.

4. Delete the statement using DEALLOCATE.

Run the deleted statement again.

The result is again an error. Description The DEALLOCATE statement has already been deleted by the precompiled statement.

About whether MySQL uses deallocate after using the Prepare Keyword precompiled statement