3
Prepared Statements
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
Define a prepare statement. -
EXECUTE Statement
Executes a previously PREPAREd statement -
DEALLOCATE / DROP PREPARE
Deallocates a prepared statement. -
EXECUTE IMMEDIATE
Immediately execute a dynamic SQL statement -
Out Parameters in PREPARE
Using question mark placeholders for out-parameters in the PREPARE statement
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.