Outdated Version
You are viewing an older version of this section. View current production version.
Procedural SQL Reference
This section contains topics about MemSQL Procedural SQL (MPSQL), which encompasses stored procedures, user-defined scalar-value functions (UDFs), user-defined table-valued functions (TVFs), and user-defined aggregate functions (UDAFs).
- Control Flow Statements
- Transactions in Stored Procedures
- Exceptions and Exception Handling
- CREATE FUNCTION (UDF)
- CREATE FUNCTION (TVF)
- CREATE PROCEDURE
- CREATE AGGREGATE
- DROP FUNCTION
- DROP PROCEDURE
- DROP AGGREGATE
- SHOW CREATE FUNCTION
- SHOW CREATE AGGREGATE
- SHOW FUNCTIONS
- SHOW AGGREGATES
- CALL
- ECHO
- ECHO SELECT
- CREATE_ARRAY
- COLLECT
- SCALAR
- ARRAY
- RECORD
- ROW
- QUERY
- Definer Security Model