In addition to using prepared statements from the libmysqld, you can also do prepared statements from any client by using the text based prepared statement interface.
You first prepare the statement with PREPARE, execute with EXECUTE, and release it with DEALLOCATE.
-
PREPARE statement
Syntax PREPARE stmt_name FROM preparable_stmtDescription The PREPARE state... -
EXECUTE statement
Syntax EXECUTE stmt_name [USING @var_name [, @var_name] ...]Description... -
DEALLOCATE / DROP prepared statement
Syntax {DEALLOCATE | DROP} PREPARE stmt_nameDescription To deallocate a pre...
