Skip to content
MatrixOne Docs
Building from source code
English
中文简体
Initializing search
matrixorigin/matrixone
MatrixOne
MatrixOne Docs
matrixorigin/matrixone
MatrixOne
MatrixOne
Home
Overview
Overview
MatrixOne Introduction
MatrixOne Feature List
MatrixOne Architecture Design
MySQL Compatibility
What's New
Getting Started
Getting Started
Deploy standalone MatrixOne
Deploy standalone MatrixOne
Overview
Deploy on macOS
Deploy on macOS
Building from source code
Using binary package
Using Docker
Deploy on Linux
Deploy on Linux
Building from source code
Building from source code
Table of contents
Step 1: Install Go as necessary dependency
Step 2: Install GCC as necessary dependency
Step 3: Get MatrixOne code
Step 4: Launch MatrixOne server
Step 5: Connect to standalone MatrixOne
Install and configure MySQL Client
Connect to MatrixOne
Using binary package
Using Docker
Basic SQL
Developing Guide
Developing Guide
Schema Design
Schema Design
Overview
Create Database
Create Table
Data Integrity
Data Integrity
Data Integrity Constraints Overview
NOT NULL Constraints
UNIQUE KEY Constraints
PRIMARY KEY Constraints
FOREIGN KEY Constraints
Connect to MatrixOne
Connect to MatrixOne
MatrixOne SSL connection
Connecting to MatrixOne with Database Client Tool
Java connect to MatrixOne
Java connect to MatrixOne
Connect MatrixOne with JDBC
Connect MatrixOne with Java ORMs
Python connect to MatrixOne
Import Data
Import Data
Insert
Bulk Load
Bulk Load
Bulk Load Overview
Import .csv format data
Import jsonlines format data
Import data from S3
Export Data
Export Data
Export data by SELECT INTO...OUTFILE
Export data by modump
Read Data
Read Data
Query Data from a Single Table
Multi-table Join Queries
Subquery
Views
Common Table Expression
Transactions
Transactions
General Transaction Overview
Transaction by MatrixOne Server
Transaction by MatrixOne Server
Transaction Overview
Explicit Transaction
Implicit Transaction
Optimistic Transaction
How to use transaction
Isolation Level
MVCC
Transaction Scenario
Deploying
Deploying
MatrixOne distributed cluster deployment
Tutorials
Tutorials
Build a Java CRUD demo
Build a CRUD demo with SpringBoot and Spring JPA
Build a CRUD demo with SpringBoot and MyBatis
Build a simple Python+SQLAlchemy CRUD demo
Build a simple Python CRUD demo
Maintenance
Maintenance
Backup and Restore
Mount Data
Mount Data
Mount directory to Docker container
Migrating
Migrating
From MySQL to MatrixOne
Testing
Testing
Performance Testing
Performance Testing
SSB Test with MatrixOne
TPCH Test with MatrixOne
TPCC Test with MatrixOne
Testing Tool
Testing Tool
MO-Tester
MO-Tester Specification
Performance Tuning
Performance Tuning
SQL Performance Tuning Methods Overview
Understanding the Query Execution Plan
Understanding the Query Execution Plan
Query Execution Plan Overview
Using EXPLAIN to learn the execution plan
Explain Statements Using JOIN
Explain Statements Using Subqueries
Explain Statements Using Aggregation
EXPLAIN Statements Using Views
Performance tuning best practices
Performance tuning best practices
Using Cluster by for performance tuning
Privilege
Privilege
TLS Introduction
What is MatrixOne Privilege Management
What is MatrixOne Privilege Management
About MatrixOne Privilege Management
Best Practices
User Guide
User Guide
Quick Start
Quick Start
Create accounts, Verify Resource Isolation
Use the new account to creates users, roles, grant the privilege
Privileges Management User guide
Application Scenario
Reference
Reference
Language Structure
Language Structure
Keywords
SQL Reference
SQL Reference
Data Definition Language
Data Definition Language
CREATE DATABASE
CREATE INDEX
CREATE TABLE
CREATE EXTERNAL TABLE
CREATE VIEW
ALTER VIEW
DROP DATABASE
DROP INDEX
DROP TABLE
DROP VIEW
TRUNCATE TABLE
Data Manipulation Language
Data Manipulation Language
INSERT
INSERT INTO SELECT
DELETE
UPDATE
LOAD DATA
INTERVAL
Information Functions
Information Functions
LAST_QUERY_ID()
LAST_INSERT_ID()
OPERATORS
OPERATORS
OPERATORS Overview
OPERATORS Precedence
Arithmetic Operators
Arithmetic Operators
Arithmetic Operators Overview
%,MOD
*
+
-
-
/
DIV
Assignment Operators
Assignment Operators
Assignment Operators Overview
=
Bit Functions and Operators
Bit Functions and Operators
Bit Functions and Operators Overview
&
>>
<<
^
|
~
Cast Functions and Operators
Cast Functions and Operators
Cast Functions and Operators Overview
CAST
CONVERT
Comparison Functions and Operators
Comparison Functions and Operators
Comparison Functions and Operators Overview
>
>=
<
<>,!=
<=
=
BETWEEN ... AND ...