Outdated Version
You are viewing an older version of this section. View current production version.
Procedural SQL Reference
This section contains topics about SingleStore (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
- Exceptions and Exception Handling
- MySQL Client Delimiters
- Transactions in Stored Procedures
- 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
- ARRAY
- CALL
- INSERT_ALL
- CREATE_ARRAY
- COLLECT
- ECHO
- ECHO SELECT
- EXECUTE IMMEDIATE
- RECORD
- ROW
- QUERY
- SCALAR
- TO_QUERY
