Introduction
Deploy
Connect to SingleStore
Create a Database
Integrate with SingleStore
Load Data
Query Data
Manage Data
Developer Resources
User and Cluster Administration
Reference
Configuration Reference
SingleStore Operator Reference
SingleStore Tools 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 Cluster Level Lock
User-Defined Variables
Restricted Keywords
Aggregate Functions
Cluster 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
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
DETACH DATABASE
FULLTEXT SERVICE STOP
KILL CONNECTION and KILL QUERY
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE DATABASE
SELECT GLOBAL
SET AGGREGATOR
SET and SET SESSION
SET CLUSTER
SET GLOBAL
SET LEAF
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
SYNC BOTTOMLESS DATABASE
Replication Distribution Tree
Pipelines Commands
Procedural SQL Reference
Regular Expression Functions
Resource Pool Commands
Security Management Commands
SHOW Commands
String Functions
Time Series Functions
Vector Functions
Window Functions
Troubleshooting Reference
System Databases
Information Schema Reference
Data API
Security
Release Notes
Support
Glossary
This command is deprecated.
Last modified: April 24, 2021