Getting Started with SingleStore Helios
Connect to SingleStore
Create a Database
Integrate with SingleStore Helios
Load Data
Query Data
Manage Data
Developer Resources
User and Workspace Administration
Security
Reference
Configuration Reference
Information Schema Reference
SQL Reference
SQL Command Syntax
SQL Commands List
SQL Functions List
Comparison Operators and Functions
Database Object Case-Sensitivity
Data Types
Character Encoding
Operations that Take Either a Database or a Workspace Level Lock
User-Defined Variables
Restricted Keywords
Aggregate Functions
BSON Functions
Workspace Management Commands
Code Generation Functions
Conditional Functions
Data Definition Language DDL
Data Manipulation Language DML
Date and Time Functions
Distinct Count Estimation Functions
Full-Text Search Functions
Geospatial Functions
Identifier Generation Functions
Information Functions
JSON Functions
Numeric Functions
Operational Commands
Pipelines Commands
Procedural SQL Reference
Anonymous Code Blocks
Control Flow Statements
Exceptions and Exception Handling
MySQL Client Delimiters
Transactions in Stored Procedures
Extensions
CREATE AGGREGATE
CREATE [OR REPLACE] EXTERNAL FUNCTION
CREATE FUNCTION (UDF)
CREATE FUNCTION (TVF)
CREATE PROCEDURE
CREATE [OR REPLACE] TEMPORARY PROCEDURE …
DROP FUNCTION
DROP PROCEDURE
DROP AGGREGATE
SHOW AGGREGATES
SHOW CREATE FUNCTION
SHOW CREATE AGGREGATE
SHOW FUNCTIONS
SHOW PROCEDURES
%ROWTYPE and %TYPE
ARRAY
CALL
CREATE_ARRAY
COLLECT
ECHO
ECHO SELECT
EXECUTE IMMEDIATE
INSERT_ALL
RECORD
ROW
QUERY
SCALAR
TO_QUERY
Regular Expression Functions
Resource Pool Commands
Security Management Commands
SHOW Commands
String Functions
Time Series Functions
Trace Event Commands
Vector Functions
Window Functions
Troubleshooting Reference
System Databases
Master Aggregator High Availability After Availability Zone Failure
Data API
Management API
Code Engine - Powered by Wasm
SingleStore Kai
Release Notes
Support
Glossary
See SHOW FUNCTIONS.
Last modified: May 6, 2021