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 |
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/prepared-statements/