Stored Routine Statements

This section covers SQL commands for creating, altering, and dropping stored procedures and functions, essential for programmatic database logic.

CALL

Invoke a stored procedure. This statement executes a previously created stored procedure, optionally passing parameters and returning results.

DO

Execute expressions without returning a result set. This statement runs functions or expressions, often used for side effects like releasing locks.

CREATE PROCEDURE

Define a new stored procedure, specifying its name, parameters (IN, OUT, INOUT), and the SQL statements it executes.

ALTER PROCEDURE

Modify the characteristics of an existing stored procedure, such as its security context or comment, without changing its logic.

DROP PROCEDURE

Remove a stored procedure and its associated privileges from the database.

DROP FUNCTION

Remove a stored function from the database, deleting its definition and associated privileges.