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.
Title | Description |
---|---|
PREPARE Statement | Define a prepare statement. |
Out Parameters in PREPARE | Using question mark placeholders for out-parameters in the PREPARE statement |
EXECUTE Statement | Executes a previously PREPAREd statement |
DEALLOCATE / DROP PREPARE | Deallocates a prepared statement. |
EXECUTE IMMEDIATE | Immediately execute a dynamic SQL 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.
© 2021 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/prepared-statements/