In order to use MySQL prepared statement, you need to use other three MySQL statements as follows:
- PREPARE – Prepares statement for execution.
- EXECUTE – Executes a prepared statement preparing by a PREPARE statement.
- DEALLOCATE PREPARE – Releases a prepared statement.
Let’s take a look at an example of using the MySQL prepared statement.
PREPARE stmt1 FROM 'SELECT productCode, productName FROM products WHERE productCode = ?'; SET @pc = 'S10_1678'; EXECUTE stmt1 USING @pc; DEALLOCATE PREPARE stmt1;
Here, first we used the PREPARE statement to prepare a statement. We used SELECT query with question mark (?) as a placeholder for the product code.
Next, we declared a product code variable
@pc and set it values to
Then, we used the
EXECUTE statement to execute the prepared statement with product code variable
Finally, we used the
DEALLOCATE PREPARE to release the prepared statement.