SQL Reference¶
This section provides a quick reference for SQL available on MatrixOne instances: structure and syntax, data types, statement categories, functions and operators, system variables and system tables, privilege categories, and notes on certain capability boundaries.
Use it to quickly determine whether a feature exists, what it is called, and how it is categorized. For instance console operations, see Guide · MatrixOne. For programmatic connections and drivers, see Developer.
MatrixOne SQL aims to follow familiar MySQL 8.0 protocol and syntax conventions while extending them with vectors, Stage, publication and subscription, snapshots / PiTR, and other capabilities. The following pages are condensed by topic and are not a page-by-page mirror of the open-source documentation.
Pages in This Section¶
Page |
Content |
|---|---|
Comments, identifiers, reserved keywords |
|
Numeric, string, time, JSON, VECTOR, and other types |
|
DDL / DML / DQL / DCL / TCL / administrative statement lists |
|
Comprehensive function tables by category |
|
Arithmetic, comparison, logical, bitwise, CAST, CASE/IF, and other operators |
|
Global / session variables and commonly used variables |
|
System databases such as |
|
List of SQL privileges within a tenant |
|
Summary of differences from MySQL, including LOAD DATA and partitioning |
How to Use This Section with the Guides¶
What you want to do |
Where to go |
|---|---|
Create, connect to, monitor, and understand billing for an instance |
|
Configure users and roles in an instance |
|
AI Studio workspace roles and privilege points |
|
Run SQL against the Catalog |
SQL Editor (if available) |