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
ANALYZE
ATTACH DATABASE
BACKUP DATABASE
CHECK BLOB CHECKSUM
CHECK BOTTOMLESS CHECKSUM
DETACH DATABASE
FULLTEXT SERVICE STOP
KILL CONNECTION and KILL QUERY
KILLALL QUERIES
REPAIR DATABASE
RESTORE DATABASE
SELECT GLOBAL
SET and SET SESSION
SET AGGREGATOR
SET CLUSTER
SET GLOBAL
SET LEAF
SHOW REPLICATION STATUS
Replication Distribution Tree
SNAPSHOT DATABASE
SYNC BOTTOMLESS DATABASE
Pipelines Commands
Procedural SQL Reference
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
This command is deprecated.
Last modified: April 24, 2021