Overview
In general, the prepared statement is executed through the interface functions of JDBC, PHP, or ODBC; it can also be executed in the SQL level. The following SQL statements are provided for execution of prepared statement.
- Prepare the SQL statement to execute.
- PREPARE stmt_name FROM preparable_stmt
- Execute the prepared statement.
- EXECUTE stmt_name [USING value [, value] …]
- Drop the prepared statement.
- {DEALLOCATE | DROP} PREPARE stmt_name