×
思维导图备注
MatrixOne v0.7.0 Documentation
首页
白天
夜间
小程序
阅读
书签
我的书签
添加书签
移除书签
Code Style
Github
来源:MatrixOne
浏览
136
扫码
分享
2023-07-06 09:12:48
Code of Conduct
Code Comment Style
Commit & Pull Request Style
当前内容版权归
MatrixOne
或其关联方所有,如需对内容或内容相关联开源项目进行关注与资助,请访问
MatrixOne
.
上一篇:
下一篇:
版本
MatrixOne v1.1 中文文档
MatrixOne v1.1 Documentation
MatrixOne v1.0 中文文档
MatrixOne v0.8.0 中文文档
MatrixOne v0.8.0 Documentation
MatrixOne v0.7.0 Documentation
MatrixOne v0.7.0 中文文档
MatrixOne v0.6.0 Documentation
MatrixOne v0.6.0 中文文档
MatrixOne v0.5.1 Documentation
MatrixOne v0.4 中文文档
MatrixOne v0.4 Documentation
MatrixOne v0.3 中文文档
MatrixOne v0.3 Documentation
Home
Overview
MatrixOne Introduction
MatrixOne Feature List
MatrixOne Architecture Design
MySQL Compatibility
What’s New
Getting Started
Deploy standalone MatrixOne
Overview
Deploy on macOS
Building from source code
Using binary package
Using Docker
Deploy on Linux
Building from source code
Using binary package
Using Docker
Basic SQL
Developing Guide
Schema Design
Overview
Create Database
Create Table
Data Integrity
Data Integrity Constraints Overview
NOT NULL Constraints
UNIQUE KEY Constraints
PRIMARY KEY Constraints
FOREIGN KEY Constraints
Connect to MatrixOne
MatrixOne SSL connection
Connecting to MatrixOne with Database Client Tool
Java connect to MatrixOne
Connect MatrixOne with JDBC
Connect MatrixOne with Java ORMs
Python connect to MatrixOne
Import Data
Insert
Bulk Load
Bulk Load Overview
Import .csv format data
Import jsonlines format data
Import data from S3
Export Data
Export data by SELECT INTO…OUTFILE
Export data by modump
Read Data
Query Data from a Single Table
Multi-table Join Queries
Subquery
Views
Common Table Expression
Transactions
General Transaction Overview
Transaction by MatrixOne Server
Transaction Overview
Explicit Transaction
Implicit Transaction
Optimistic Transaction
How to use transaction
Isolation Level
MVCC
Transaction Scenario
Deploying
MatrixOne distributed cluster deployment
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
Backup and Restore
Mount Data
Mount directory to Docker container
Migrating
From MySQL to MatrixOne
Testing
Performance Testing
SSB Test with MatrixOne
TPCH Test with MatrixOne
TPCC Test with MatrixOne
Testing Tool
MO-Tester
MO-Tester Specification
Performance Tuning
SQL Performance Tuning Methods Overview
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
Using Cluster by for performance tuning
Privilege
TLS Introduction
What is MatrixOne Privilege Management
About MatrixOne Privilege Management
Best Practices
User Guide
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
Language Structure
Keywords
SQL Reference
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
INSERT
INSERT INTO SELECT
DELETE
UPDATE
LOAD DATA
INTERVAL
Information Functions
LAST_QUERY_ID()
LAST_INSERT_ID()
OPERATORS
OPERATORS Overview
OPERATORS Precedence
Arithmetic Operators
Arithmetic Operators Overview
%,MOD
*
+
-
-
/
DIV
Assignment Operators
Assignment Operators Overview
\=
Bit Functions and Operators
Bit Functions and Operators Overview
&
>>
<<
^
|
~
Cast Functions and Operators
Cast Functions and Operators Overview
CAST
CONVERT
Comparison Functions and Operators
Comparison Functions and Operators Overview
>
>=
<
<>,!=
<=
\=
BETWEEN … AND …
IN
IS
IS NOT
IS NOT NULL
IS NULL
LIKE
NOT BETWEEN … AND …
NOT LIKE
COALESCE
Flow Control Functions
Flow Control Functions Overview
CASE WHEN
IF
Logical Operators
Logical Operators Overview
AND,&&
NOT,!
OR
XOR
Data Query Language
SELECT
SUBQUERY
SUBQUERY Overview
Derived Tables
Comparisons Using Subqueries
SUBQUERY with ANY or SOME
SUBQUERY with ALL
SUBQUERY with EXISTS
SUBQUERY with IN
JOIN
JOIN Overview
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL JOIN
OUTER JOIN
NATURAL JOIN
With CTE
Combining Queries
Combining Queries Overview
UNION
INTERSECT
MINUS
Data Control Language
CREATE ACCOUNT
ALTER ACCOUNT
CREATE ROLE
CREATE USER
DROP ACCOUNT
DROP USER
DROP ROLE
GRANT
REVOKE
Other
SHOW
SHOW ACCOUNTS
SHOW DATABASES
SHOW CREATE TABLE
SHOW CREATE VIEW
SHOW TABLES
SHOW INDEX
SHOW COLLATION
SHOW COLUMNS
SHOW GRANT
SHOW VARIABLES
SET
SET ROLE
USE
USE DATABASE
Prepared Statements
Prepared Statements Overview
PREPARE
EXECUTE
DEALLOCATE
Explain
EXPLAIN
EXPLAIN Output Format
Explain Analyze
Aggregate Functions
ANY_VALUE
AVG
BIT_AND
BIT_OR
BIT_XOR
COUNT
GROUP_CONCAT
MAX
MEDIAN
MIN
SLEEP
STDDEV_POP
SUM
System variable
Custom variable
Data Types
Data Types Overview
Data Type Conversion
Timestamp Initialization
JSON Data Type
BLOB and TEXT Type
Fixed-Point Types (Exact Value) - DECIMAL
Builtin Functions
Mathematical
ABS()
ACOS()
ATAN()
CEIL()
COS()
COT()
EXP()
FLOOR()
LN()
LOG()
PI()
POWER()
ROUND()
SIN()
SINH()
TAN()
UUID()
Datetime
CURDATE()
CURRENT_TIMESTAMP()
DATE()
DATE_ADD()
DATE_FORMAT()
DATE_SUB()
DATEDIFF()
DAY()
DAYOFYEAR()
EXTRACT()
FROM_UNIXTIME
MONTH()
TIMEDIFF()
TIMESTAMP()
TO_DATE()
UNIX_TIMESTAMP
UTC_TIMESTAMP()
WEEKDAY()
YEAR()
String
BIN()
BIT_LENGTH()
CHAR_LENGTH()
CONCAT()
CONCAT_WS()
EMPTY()
ENDSWITH()
FIELD()
FIND_IN_SET()
FORMAT()
HEX()
LEFT()
LENGTH()
LPAD()
LTRIM()
OCT()
REVERSE()
RPAD()
RTRIM()
SPACE()
STARTSWITH()
SUBSTRING()
SUBSTRING_INDEX()
TRIM()
System Paramaters
Boot Parameters for standalone installation
Time Zone Support
MatrixOne Catalog
Privilege Control Types
Limitations
JDBC supported features list
Partitioning supported features list
MatrixOne Directory Structure
Troubleshooting
Slow Queries
Common statistic data query
Database statistics
Audit
Error Code
FAQs
Product FAQs
Deployment FAQs
SQL FAQs
Release Notes
Release Timeline
v0.7.0
v0.6.0
v0.5.1
v0.5.0
v0.4.0
v0.3.0
v0.2.0
v0.1.0
Glossary
Contribution Guide
Make Your First Contribution
How to Contribute
Types of Contributions
Preparation
Report an Issue
Contribute Code
Review a Pull Request
Contribute Documentation
Make a Design
Code Style
Code of Conduct
Code Comment Style
Commit & Pull Request Style
暂无相关搜索结果!
本文档使用
BookStack
构建
×
分享,让知识传承更久远
×
文章二维码
手机扫一扫,轻松掌上读
×
文档下载
普通下载
下载码下载(免登录无限下载)
你与大神的距离,只差一个APP
请下载您需要的格式的文档,随时随地,享受汲取知识的乐趣!
PDF
文档
EPUB
文档
MOBI
文档
温馨提示
每天每在网站阅读学习一分钟时长可下载一本电子书,每天连续签到可增加阅读时长
下载码方式下载:免费、免登录、无限制。
免费获取下载码
下载码
文档格式
PDF
EPUB
MOBI
码上下载
×
微信小程序阅读
您与他人的薪资差距,只差一个随时随地学习的小程序
×
书签列表
×
阅读记录
阅读进度:
0.00%
(
0/0
)
重置阅读进度