Stored Functions

Utilize stored functions in MariaDB Server. This section details creating, using, and managing user-defined functions to extend SQL capabilities and streamline data manipulation.

Stored Function Overview

A Stored Function is a set of SQL statements that can be called by name, accepts parameters, and returns a single value, enhancing SQL with custom logic.

Stored Aggregate Functions

Stored Aggregate Functions allow users to create custom aggregate functions that process a sequence of rows and return a single summary result.

Stored Routine Privileges

This page explains the privileges required to create, alter, execute, and drop stored routines, including the automatic grants for creators.

DROP FUNCTION

The DROP FUNCTION statement removes a stored function from the database, deleting its definition and associated privileges.

Stored Function Limitations

This page details the restrictions on stored functions, such as the inability to return result sets or use transaction control statements.