MatrixOne v1.1 Documentation
首页 白天 夜间 BookChat 小程序 小程序 下载 阅读记录
  • 书签 我的书签
  • 添加书签 添加书签 移除书签 移除书签

Data Manipulation Language

来源 MatrixOne 浏览 1 扫码 打印 2026-10-29 02:03:56
    • INSERT
    • INSERT INTO SELECT
    • INSERT ON DUPLICATE KEY UPDATE
    • DELETE
    • UPDATE
    • LOAD DATA
    • REPLACE
    • Information Functions
    上一篇:
    下一篇:
    • 书签
    • 添加书签 移除书签
    • MatrixOne Documentation
    • Overview
      • MatrixOne Introduction
      • MatrixOne Feature List
      • MatrixOne Feature
        • HTAP
        • Multi-Account
        • Scalability
        • Cost-Effective
        • High Availability
        • MySQL Compatibility
      • MatrixOne Architecture Design
        • Architecture Design Overview
        • Transactional Analytical Engine Architecture
        • Detailed Logservice Architecture
        • Logtail Protocol Architecture
        • Transaction and Lock Mechanisms Architecture
        • Detailed Proxy Architecture
        • Detailed Caching and Hot-Cold Data Separation Architecture
        • Detailed Stream Engine Architecture
      • 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
      • Connect to MatrixOne
        • Connecting to MatrixOne with Database Client Tool
        • Java connect to MatrixOne
          • Connect MatrixOne with JDBC
          • Connect MatrixOne with Java ORMs
        • Python connect to MatrixOne
        • Connecting to MatrixOne with Golang
        • MatrixOne SSL connection
      • Schema Design
        • Overview
        • Create Database
        • Create Table
        • Create View
        • Create Temporary Table
        • Create Secondary Index
        • Data Integrity
          • Data Integrity Constraints Overview
          • NOT NULL Constraints
          • UNIQUE KEY Constraints
          • PRIMARY KEY Constraints
          • FOREIGN KEY Constraints
          • AUTO INCREMENT Constraints
      • Write Data
        • Import Data
          • Insert
          • Bulk Load
            • Bulk Load Overview
            • Load csv format data
            • Load jsonlines format data
            • Load data from S3
            • Load data by using the `source`
        • Update Data
        • Delete Data
        • Prepared
      • Export Data
        • Export data by SELECT INTO
        • Export data by MODUMP
      • Read Data
        • Query Data from a Single Table
        • Multi-table Join Queries
        • Subquery
        • Views
        • Common Table Expression
        • Window Function.
      • Account Design
        • Multi-Account Overview
        • Publish-Subscribe
      • Transactions
        • General Transaction Overview
        • Transaction by MatrixOne Server
          • Transaction Overview
          • Explicit Transaction
          • Implicit Transaction
          • Pessimistic Transaction
          • Optimistic Transaction
          • Isolation Level
          • MVCC
          • How to use transaction
            • User Guide
            • Scenario
      • Application Developing Tutorials
        • Java CRUD demo
        • SpringBoot and JPA CRUD demo
        • SpringBoot and MyBatis CRUD demo
        • Python CRUD demo
        • SQLAlchemy CRUD demo
        • Golang CRUD demo
        • Gorm CRUD demo
      • Ecological Tools
        • BI Tools
          • Visualizing MatrixOne Data with FineBI
          • Visualizing MatrixOne Reports with Yonghong BI
          • Visual Monitoring of MatrixOne with Superset
        • ETL Tools
          • Writing Data to MatrixOne Using SeaTunnel
          • Writing Data to MatrixOne Using DataX
        • Computing Engine
          • Writing Batch data to MatrixOne Using Spark
          • Writing Real-Time Data to MatrixOne Using Flink
        • Scheduling Tools
          • Connecting MatrixOne with DolphinScheduler
    • Deploying
      • Plan MatrixOne Cluster Topology
        • Cluster Topology Planning Overview
        • Experience Environment Deployment Plan
        • Minimum Production Environment Deployment Plan
        • Recommended Production Environment Deployment Plan
      • MatrixOne distributed cluster deployment
      • Maintenance
        • Starting and stopping
        • Updating
        • Health check and resource monitoring
        • Scaling
        • Managing CN Groups with Proxy
        • Import data from local Minio to MatrixOne
        • Operator Management
    • Maintenance
      • Backup and Restore
        • MatrixOne Backup and Recovery Overview
        • Backup and Recovery Concepts
        • Backup and Restore by using mo-dump
      • Mount Data
        • Mount directory to Docker container
    • Migrating
      • Migrate data to MatrixOne Overview
      • Migrate data from MySQL to MatrixOne
      • Migrate data from SQL Server to MatrixOne
      • Migrate data from SQL Server to MatrixOne
      • Migrate data from PostgreSQL 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
        • Scaling CN for better performance
    • Privilege
      • Security and Permissions Overview
      • Authentication and Authorization
      • Password Management
      • Access Control
        • About MatrixOne Privilege Management
        • Privilege Management Scenario
        • Best Practices
      • User Guide
        • Privileges Management Overview
        • Create accounts, Verify Resource Isolation
        • Use the new account to creates users, roles, grant the privilege
      • Data Transmission Encryption
      • Security Audit
    • Reference
      • System Variables
        • System Variables Overview
        • System Variables parameters
          • SQL Mode
          • Save query result support
          • Timezone support
          • Lowercase table names support
        • Custom variable
      • SQL Language Structure
        • Keywords
        • Comments
      • Data Types
        • Data Types Overview
        • Data Type Conversion
        • Date and Time Types
          • Timestamp Initialization
          • YEAR Type
        • JSON Data Type
        • BLOB and TEXT Type
        • ENUM Type
        • UUID Type
        • Fixed-Point Types (Exact Value/) - DECIMAL
      • SQL Statements
        • Type of SQL Statements
        • Data Definition Language
          • CREATE DATABASE
          • CREATE INDEX
          • CREATE TABLE
          • CREATE EXTERNAL TABLE
          • CREATE PUBLICATION
          • CREATE SEQUENCE
          • CREATE STAGE
          • CREATE…FROM…PUBLICATION…
          • CREATE VIEW
          • ALTER TABLE
          • ALTER PUBLICATION
          • ALTER STAGE
          • ALTER VIEW
          • DROP DATABASE
          • DROP INDEX
          • DROP TABLE
          • DROP PUBLICATION
          • DROP SEQUENCE
          • DROP STAGE
          • DROP VIEW
          • TRUNCATE TABLE
        • Data Manipulation Language
          • INSERT
          • INSERT INTO SELECT
          • INSERT ON DUPLICATE KEY UPDATE
          • DELETE
          • UPDATE
          • LOAD DATA
          • REPLACE
          • Information Functions
            • LAST_QUERY_ID(/)
            • LAST_INSERT_ID(/)
        • 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
          • ALTER USER
          • DROP ACCOUNT
          • DROP USER
          • DROP ROLE
          • GRANT
          • REVOKE
        • Other
          • SHOW
            • SHOW ACCOUNTS
            • SHOW DATABASES
            • SHOW CREATE TABLE
            • SHOW CREATE VIEW
            • SHOW CREATE PUBLICATION
            • SHOW TABLES
            • SHOW INDEX
            • SHOW COLLATION
            • SHOW COLUMNS
            • SHOW FUNCTION STATUS
            • SHOW GRANT
            • SHOW PROCESSLIST
            • SHOW PUBLICATIONS
            • SHOW ROLES
            • SHOW SEQUENCES
            • SHOW STAGE
            • SHOW SUBSCRIPTIONS
            • SHOW VARIABLES
          • SET
            • SET ROLE
          • USE
            • USE DATABASE
          • KILL
          • Prepared Statements
            • PREPARE
            • EXECUTE
            • DEALLOCATE
          • Explain
            • EXPLAIN
            • EXPLAIN Output Format
            • Explain Analyze
      • Functions and Operators
        • Operators
          • INTERVAL
          • 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
              • BINARY
              • CAST
              • CONVERT
            • Comparison Functions and Operators
              • Comparison Functions and Operators Overview
              • >
              • >=
              • <
              • <>,!=
              • <=
              • \=
              • BETWEEN … AND …
              • IN
              • IS
              • IS NOT
              • IS NOT NULL
              • IS NULL
              • ILIKE
              • ISNULL
              • LIKE
              • NOT BETWEEN … AND …
              • NOT IN
              • NOT LIKE
              • COALESCE
            • Flow Control Functions
              • Flow Control Functions Overview
              • CASE WHEN
              • IF
              • IFNULL
              • NULLIF
            • Logical Operators
              • Logical Operators Overview
              • AND,&&
              • NOT,!
              • OR
              • XOR
        • Functions
          • Aggregate Functions
            • ANY_VALUE
            • AVG
            • BIT_AND
            • BIT_OR
            • BIT_XOR
            • COUNT
            • GROUP_CONCAT
            • MAX
            • MEDIAN
            • MIN
            • STDDEV_POP
            • SUM
            • VARIANCE
          • Datetime
            • CURDATE(/)
            • CURRENT_TIMESTAMP(/)
            • DATE(/)
            • DATE_ADD(/)
            • DATE_FORMAT(/)
            • DATE_SUB(/)
            • DATEDIFF(/)
            • DAY(/)
            • DAYOFYEAR(/)
            • EXTRACT(/)
            • HOUR(/)
            • FROM_UNIXTIME
            • MINUTE(/)
            • MONTH(/)
            • SECOND(/)
            • TIME(/)
            • TIMEDIFF(/)
            • TIMESTAMP(/)
            • TIMESTAMPDIFF(/)
            • TO_DATE(/)
            • TO_DAYS(/)
            • TO_SECONDS(/)
            • UNIX_TIMESTAMP
            • UTC_TIMESTAMP(/)
            • WEEK(/)
            • WEEKDAY(/)
            • YEAR(/)
          • Mathematical
            • ABS(/)
            • ACOS(/)
            • ATAN(/)
            • CEIL(/)
            • COS(/)
            • COT(/)
            • EXP(/)
            • FLOOR(/)
            • LN(/)
            • LOG(/)
            • LOG2(/)
            • LOG10(/)
            • PI(/)
            • POWER(/)
            • RAND(/)
            • ROUND(/)
            • SIN(/)
            • SINH(/)
            • TAN(/)
          • String
            • BIN(/)
            • BIT_LENGTH(/)
            • CHAR_LENGTH(/)
            • CONCAT(/)
            • CONCAT_WS(/)
            • EMPTY(/)
            • ENDSWITH(/)
            • FIELD(/)
            • FIND_IN_SET(/)
            • FORMAT(/)
            • HEX(/)
            • INSTR(/)
            • LEFT(/)
            • LENGTH(/)
            • LPAD(/)
            • LTRIM(/)
            • OCT(/)
            • REPEAT(/)
            • REVERSE(/)
            • RPAD(/)
            • RTRIM(/)
            • SPACE(/)
            • SPLIT_PART(/)
            • STARTSWITH(/)
            • SUBSTRING(/)
            • SUBSTRING_INDEX(/)
            • TRIM(/)
            • Regular Expressions
              • Regular Expressions Overview
              • NOT REGEXP
              • REGEXP_INSTR(/)
              • REGEXP_LIKE(/)
              • REGEXP_REPLACE(/)
              • REGEXP_SUBSTR(/)
          • Table
            • UNNEST(/)
          • Window Functions
            • DENSE_RANK(/)
            • RANK(/)
            • ROW_NUMBER(/)
          • JSON Functions
          • Other Functions
            • SLEEP
            • UUID(/)
          • System OPS Functions
            • CURRENT_ROLE_NAME(/)
            • CURRENT_ROLE(/)
            • CURRENT_USER_NAME(/)
            • CURRENT_USER(/)
            • PURGE_LOG(/)
      • System Paramaters
        • System Parameters Overview
        • Standalone Common Parameters Configuration
        • Distributed Common Parameters Configuration
      • MatrixOne Catalog
      • Privilege Control Types
      • Limitations
        • JDBC supported features list
        • Partitioning supported features list
      • MatrixOne Directory Structure
      • MatrixOne Tools
        • mo_ctl Tool
    • Troubleshooting
      • Slow Queries
      • Common statistic data query
      • Database statistics
      • Error Code
    • FAQs
      • Product FAQs
      • Deployment FAQs
      • SQL FAQs
    • Release Notes
      • Release Timeline
      • v1.1.0
      • v1.0.2
      • v1.0.1
      • v1.0.0
      • v1.0.0-rc2
      • v1.0.0-rc1
      • v0.8.0
      • 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
    暂无相关搜索结果！

      本文档使用 WanXiangYunDang 构建

      展开/收起文章目录

      思维导图备注

      文章二维码

      手机扫一扫，轻松掌上读

      文档下载

      请下载您需要的格式的文档，随时随地，享受汲取知识的乐趣！
      PDF文档 EPUB文档 MOBI文档

      微信小程序阅读

      BookChat 微信小程序阅读
      微信扫一扫，知识掌上学

      书签列表

        阅读记录

        阅读进度: 0.00% ( 0/0 ) 重置阅读进度