Prepared Statements

Learn about prepared statements in MariaDB Server. This section details how to use them for efficient and secure execution of repetitive SQL queries, preventing SQL injection vulnerabilities.

DEALLOCATE / DROP PREPARE

Release a prepared statement to free resources. This command removes the statement definition and its name from the current session.

EXECUTE Statement

Run a previously prepared statement. This command executes the statement using the specified name, optionally supplying input parameters.

EXECUTE IMMEDIATE

Prepare and run a dynamic SQL statement in one step. This command simplifies the process by combining the PREPARE and EXECUTE operations.

PREPARE Statement

Parse and optimize a SQL statement for later use. This command assigns a name to the statement, enabling efficient execution with parameters.

_{This page is licensed: CC BY-SA / Gnu FDL}