Product Overview
Solutions
Documentation
Blog
Careers
Resources
Book a Demo
Product
Product Overview
Learn about the MemSQL database and its capabilities
Learn More
PRODUCTS
Ingest Data
ETL in real-time
Manage and Monitor
With powerful tooling
FAQ
Frequently asked questions
SERVICES
Support Plans
Professional Services
Training
Contact Us
Solutions
INDUSTRY
Financial
Media
Energy
Government
Retail
High-Tech
USE CASE
Analytics
Internet of Things
Secure Govt Data
Risk Management
Monitoring
Customer 360
Hadoop Acceleration
OLTP Acceleration
Docs
Documentation
From basic FAQs to in-depth tech docs.
Read Docs
NEW
6.7 Release Notes
Dynamic SQL
MemSQL Studio
More
GETTING STARTED
How MemSQL Works
Installation
Tutorials
More
HELP
Troubleshooting
Community Forums
Enterprise Support
Blog
Case Study: MemSQL Powering AI Breakthroughs at diwo
diwo® is a new, AI-powered platform that promises to help business users answer real-life challenges, acting as their “cognitive decision-making superpower.” diwo – which stands for “data in, wisdom out” – uses MemSQL to power a significant part of its functionality. diwo was developed to reveal hidden business opportunities and empower users to act on them in a timely manner. The software can run in an AI-powered conversational mode, rather than through a programming or scripting language (though many layers of sophisticated coding underline the system). diwo’s conversational persona, ASK, is powered by a series of distributed microservices, and uses …
Read Blog
Choosing a Time Series Database
Time series data is as old as databases themselves – and also the hot new thing. Interest in the topic has more than doubled during this decade. In a previous blog post, we described how time series data is used and stored. In this blog post, we look at the desirable characteristics of a time series database and evaluate our own database, MemSQL, against those requirements. Time series data is more and more widely used. Part of the growth comes from the fact that time series data is at the core of the Internet of Things, with frequent sensor readings …
Read Blog
Augmenting Hadoop with MemSQL for Faster Analytics at a …
A Fortune 50 company tried traditional SQL databases, then Hadoop, to manage financial updates company-wide. They finally found a successful solution by augmenting Hadoop with MemSQL. Many companies today are straining to meet the needs for faster ad hoc analytics, dashboards, reporting, and support for modern applications that depend on fast access to the latest data – in particular, financial data. Facing competitive and customer pressures, IT organizations must respond to a rapid increase in the volume of incoming data and the needs of the business to use this data for rapid decision-making, improving operations, and providing better customer experiences. …
Read Blog
Resources
An Intro to MemSQL
A 30-minute webinar to understand how it works
Learn More
FEATURED RESOURCES
Customers
Case Studies
News Articles
Webcasts
eBooks
Whitepapers
Industry Reports
Contact Us
Sign In
Download
Back
Introduction
Guides
Installation Configuration
Tutorials
Concepts
Operations
Integrations
Security
Troubleshooting
SQL Reference
V5.0
V5.1
V5.5
V5.7
V5.8
V6.0
V6.5
V6.7
SQL Reference Overview
Aggregate Functions
AVG
COUNT
GROUP_CONCAT
MAX
MIN
STD
STDDEV_SAMP
SUM
VARIANCE
VAR_SAMP
Cluster Management Commands
Node Requirements for MemSQL Commands
ADD AGGREGATOR
ADD LEAF
AGGREGATOR SET AS MASTER
ATTACH LEAF
ATTACH LEAF ALL
BOOTSTRAP AGGREGATOR
DETACH LEAF
EXPLAIN REBALANCE PARTITIONS
REBALANCE PARTITIONS
REMOVE AGGREGATOR
REMOVE LEAF
RESTORE REDUNDANCY
SHOW AGGREGATORS
SHOW LEAVES
SHOW CLUSTER STATUS
SHOW REBALANCE STATUS
Comparison Operators and Functions
Conditional Functions
CASE
COALESCE
CONVERT
DECODE
ELT
GREATEST
IF
ISNULL
LEAST
NULLIF
NVL and IFNULL
SLEEP
Date and Time Functions
ADDTIME
CONVERT_TZ
CURRENT_DATE
CURRENT_TIME
CURRENT_TIMESTAMP
DATE
DATEDIFF
DATE_ADD
DATE_FORMAT
DATE_SUB
DATE_TRUNC
DAY
DAYNAME
DAYOFWEEK
DAYOFYEAR
EXTRACT
FROM_DAYS
FROM_UNIXTIME
GET_FORMAT
HOUR
LAST_DAY
LOCALTIMESTAMP
MINUTE
MONTH
MONTHNAME
MONTHS_BETWEEN
QUARTER
SECOND
SEC_TO_TIME
STR_TO_DATE
TIME
TIMEDIFF
TIMESTAMP
TIMESTAMPADD
TIMESTAMPDIFF
TIME_FORMAT
TIME_TO_SEC
TO_CHAR
TO_DATE
TO_DAYS
TO_SECONDS
TO_TIMESTAMP
UNIX_TIMESTAMP
UTC_DATE
UTC_TIME
UTC_TIMESTAMP
WEEK
WEEKDAY
YEAR
Data Definition Language (DDL)
ALTER TABLE
ALTER VIEW
CREATE DATABASE
CREATE INDEX
CREATE VIEW
CREATE TABLE
DESCRIBE
DROP DATABASE
DROP INDEX
DROP ... FROM PLANCACHE
DROP TABLE
DROP VIEW
FLUSH TABLES
OPTIMIZE TABLE
TRUNCATE
UNLOCK TABLES
Data Manipulation Language (DML)
BEGIN
COMMIT
CUBE, ROLLUP and GROUPING()
DELETE
EXCEPT and MINUS
EXPLAIN
INSERT
INTERSECT
LOAD DATA
PROFILE
PIVOT
REPLACE
ROLLBACK
SELECT
UNION
UPDATE
USE
WITH (Common Table Expressions)
Data Types
Distinct Count Estimation Functions
APPROX_COUNT_DISTINCT
APPROX_COUNT_DISTINCT_ACCUMULATE
APPROX_COUNT_DISTINCT_COMBINE
APPROX_COUNT_DISTINCT_ESTIMATE
Procedural SQL Reference
Control Flow Statements
Exceptions and Exception Handling
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
JSON Functions
JSON_ARRAY_CONTAINS_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_EXTRACT_<type>
JSON_GET_TYPE
JSON Keypaths
JSON_LENGTH
JSON_SET_<type>
JSON_SPLICE_<type>
Geospatial Functions
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_AREA
GEOGRAPHY_CONTAINS
GEOGRAPHY_DISTANCE
GEOGRAPHY_INTERSECTS
GEOGRAPHY_LATITUDE
GEOGRAPHY_LENGTH
GEOGRAPHY_LONGITUDE
GEOGRAPHY_POINT
GEOGRAPHY_WITHIN_DISTANCE
Numeric Functions
ABS
SIGN
EXP
ACOS
ASIN
ATAN
ATAN2, ATAN
BIT_COUNT
bitwise AND (&)
bitwise NOT (~)
bitwise OR (|)
bitwise XOR (^)
bitwise left shift (<<)
bitwise right shift (>>)
CEIL
CONV
COS
COT
LN
LOG2
LOG10
DEGREES
FLOOR
LAST_INSERT_ID
LOG
PI
POW
RADIANS
RAND
ROUND
SIN
SQRT
TAN
TRUNCATE
Information Functions
ROW_COUNT
Operational Commands
ANALYZE
BACKUP
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE
SELECT GLOBAL
SET GLOBAL
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
Regular Expression Functions
REGEXP_INSTR
REGEXP_REPLACE
RLIKE and REGEXP
Resource Pool Commands
ALTER RESOURCE POOL
CREATE RESOURCE POOL
DROP RESOURCE POOL
SHOW RESOURCE POOLS
Security Management Commands
CREATE GROUP
CREATE ROLE
CREATE USER
ALTER USER
CURRENT_USER
DROP GROUP
DROP ROLE
DROP USER
GRANT
GRANT GROUP
GRANT ROLE
REVOKE
REVOKE GROUP
REVOKE ROLE
SET PASSWORD
SHOW GRANTS
SHOW GROUPS
SHOW GROUPS FOR ROLE
SHOW GROUPS FOR USER
SHOW ROLES
SHOW ROLES FOR GROUP
SHOW ROLES FOR USER
SHOW USERS
SHOW USERS FOR GROUP
SHOW USERS FOR ROLE
Permissions Matrix
Default Mode Permissions Changes
Strict Mode Permissions
SHOW Commands
SHOW CREATE PIPELINE
SHOW COLUMNS
SHOW DATABASES
SHOW GLOBAL STATUS
SHOW GLOBAL VARIABLES
SHOW INDEX
SHOW INDEXES
SHOW KEYS
SHOW LOAD ERRORS
SHOW LOAD WARNINGS
SHOW PIPELINES
SHOW PLANCACHE
SHOW PROCESSLIST
SHOW SCHEMAS
SHOW SESSION STATUS
SHOW SESSION VARIABLES
SHOW STATUS [EXTENDED]
SHOW TABLE STATUS
SHOW TABLES
SHOW VARIABLES
SHOW WARNINGS
String Functions
AES_DECRYPT
AES_ENCRYPT
ASCII
BIN
BINARY
CHAR
CHARACTER_LENGTH
CONCAT
CONCAT_WS
CRC32
FIELD
FORMAT
FROM_BASE64
QUOTE
HEX
INET_ATON
INET_NTOA
INSTR
LCASE
LEFT
LENGTH
LOCATE
LPAD
LTRIM
MD5
RIGHT
RPAD
RTRIM
SHA1
SHA2
SUBSTRING
SUBSTRING_INDEX
TO_BASE64
TRIM
UCASE
UNHEX
Vector Functions
DOT_PRODUCT
VECTOR_SUB
EUCLIDEAN_DISTANCE
JSON_ARRAY_PACK
Full Text Search Functions
HIGHLIGHT
MATCH
Window Functions
DENSE_RANK
FIRST_VALUE
LAG
LAST_VALUE
LEAD
NTH_VALUE
NTILE
PERCENT_RANK
PERCENTILE_CONT and Median
PERCENTILE_DISC
RANK
ROW_NUMBER
Pipelines Commands
ALTER PIPELINE
CREATE PIPELINE
DROP PIPELINE
EXTRACT PIPELINE ... INTO OUTFILE
PROFILE PIPELINE
SHOW CREATE PIPELINE
SHOW PIPELINES
START PIPELINE
STOP PIPELINE
TEST PIPELINE
Configuration Reference
MemSQL Studio
MemSQL Tools Reference
MemSQL Pipelines
MemSQL And Spark
MemSQL Ops
MemSQL Ops CLI Reference
Release Notes
Deprecations
/
SQL Reference
/
V5.0
V5.1
V5.5
V5.7
V5.8
V6.0
V6.5
V6.7
/
Operational Commands
Operational Commands
This page contains a list of all operational commands in MemSQL:
ANALYZE
BACKUP
CLEAR ORPHAN DATABASES
CONTINUE REPLICATING
KILL CONNECTION
KILLALL QUERIES
PAUSE REPLICATING
REPAIR DATABASE
REPLICATE DATABASE
RESTORE
SELECT GLOBAL
SET GLOBAL
SHOW REPLICATION STATUS
SNAPSHOT DATABASE
STOP REPLICATING
Was this article useful?
Yes
No
Sorry about that
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or feedback
Email (if you'd like us to respond to you)
Send