Skip to content

MatrixOne Intelligence 文档

Logical Operators Overview

English
中文简体

Initializing search

MatrixOne Intelligence
MatrixOne

MatrixOne Intelligence 文档

MatrixOne Intelligence
MatrixOne Intelligence
- Home
- About MatrixOne Intelligence
  About MatrixOne Intelligence
  - Introduction to MatrixOne Intelligence
- Quick Start
  Quick Start
- GenAI Workspace
  GenAI Workspace
  - Overview
  - Workspace Management
  - Data Integration
    Data Integration
    
    Connectors
    
    Data Loading
    
    Data Export
  - Data Processing
    Data Processing
    
    Workflow Templates
    Workflow Templates
    
    Overview
    
    RAG Data Preparation for Text-Image Documents
    
    Talent Resume Information Extraction
    
    Legal Knowledge Fine-Tuning Data Generation
    
    Workflows
    
    Jobs
  - Data Exploration
    Data Exploration
    
    Data Center
    
    Data Retrieval
  - Alerts
  - User Permissions
    User Permissions
    
    User Management
    
    Role Management
  - Application Development
    Application Development
    
    MCP Usage Instructions
    
    Deerflow Integration with MOI RAG Service Usage Instructions
  - API
    API
    
    Workflow API Documentation
    Workflow API Documentation
    
    API Key
    
    Data Integration
    
    Data Processing
    
    Data Exploration
    
    Metrics
    
    Quick Start API Documentation
    Quick Start API Documentation
    
    Structured Extraction
- Database Instance
  Database Instance
  - MySQL Compatibility
  - Instance Management
    Instance Management
    
    Create an Instance
    Create an Instance
    
    Create a Serverless Instance
    
    Create a Standard Instance
    
    Connect to an Instance
    
    Log in to an Instance
    
    Terminate and Restore an Instance
  - Data Sharing
  - Backup and Restore
    Backup and Restore
    
    Snapshots
  - Data Migration and Import
    Data Migration and Import
    
    Import TPCH Sample Data
    
    Import Data from Object Storage
    
    Import Local Data
    
    MySQL Data Migration
  - Data Export
  - Data Exploration
    Data Exploration
    
    SQL Editor
    
    SQL Workbook
    
    Query Analysis
    Query Analysis
    
    Query History
    
    Query Analysis
  - Application Development
    Application Development
    
    Connect to a Database Instance
    Connect to a Database Instance
    
    Connect with Client Tools
    
    Connect via Web Page
    
    Java Connection
    Java Connection
    
    JDBC Connection
    
    Java ORMs Connection
    
    Python Connection
    
    Golang Connection
    
    C# Connection
    
    Database Schema Design
    Database Schema Design
    
    Overview
    
    Create a Database
    
    Create a Table
    
    Create a View
    
    Create a Temporary Table
    
    Create a Secondary Index
    
    Create Constraints
    Create Constraints
    
    Constraints Overview
    
    NOT NULL Constraint
    
    UNIQUE KEY Constraint
    
    PRIMARY KEY Constraint
    
    FOREIGN KEY Constraint
    
    AUTO INCREMENT Constraint
    
    Data Writing
    Data Writing
    
    Insert Data
    Insert Data
    
    INSERT
    
    Stream Import
    
    Bulk Insert
    Bulk Insert
    
    Bulk Insert Overview
    
    Insert CSV Files
    
    Insert JSONLines Files
    
    Import Files from Object Storage
    
    Insert via Source
    
    Update Data
    
    Delete Data
    
    Prepared Statements
    
    Data Reading
    Data Reading
    
    Single Table Query
    
    Multi-Table Join Query
    
    Subqueries
    
    Views
    
    Common Table Expressions (CTEs)
    
    Application Development Examples
    Application Development Examples
    
    Basic Java Example
    
    Basic Python Example
    
    SpringBoot and JPA Example
    
    SpringBoot and MyBatis Example
    
    SQLAlchemy Example
    
    Django Example
    
    Golang Example
    
    Gorm Example
    
    C# Example
    
    Transactions
    Transactions
    
    General Transaction Concepts
    
    MatrixOne Intelligence Transactions
    MatrixOne Intelligence Transactions
    
    Overview
    
    Explicit Transactions
    
    Implicit Transactions
    
    Pessimistic Transactions
    
    Optimistic Transactions
    
    Isolation Levels
    
    MVCC
    
    How to Use MatrixOne Intelligence Transactions
    How to Use MatrixOne Intelligence Transactions
    
    Usage Guide
    
    Application Scenarios
  - Security
    Security
    
    Identity and Access Control
    
    Network Access Control
    Network Access Control
    
    Set IP Whitelist
    
    TLS Connection to MatrixOne
    
    Private Network Connection
    
    Data Access Control
    Data Access Control
    
    Role-Based Access Control (RBAC)
  - Reference Manual
    Reference Manual
    
    System Variables
    System Variables
    
    System Variables Overview
    
    System Variable Parameters
    System Variable Parameters
    
    SQL Mode
    
    Query Result Saving Support
    
    Timezone Support
    
    Case Sensitivity Support
    
    Foreign Key Check Support
    
    Query Result Column Name Consistency
    
    Illegal Login Restrictions
    
    Password Complexity Check
    
    Connection Whitelist
    
    Custom Variables
    
    SQL Structure and Syntax
    SQL Structure and Syntax
    
    Keywords
    
    Comments
    
    Data Types
    Data Types
    
    Data Types Overview
    
    Data Type Conversion
    
    Date and Time Types
    Date and Time Types
    
    TIMESTAMP and DATETIME Auto-Initialization and Update
    
    YEAR Type
    
    JSON Data Type
    
    BLOB and TEXT Data Types
    
    DATALINK Data Type
    
    ENUM Type
    
    UUID Data Type
    
    Fixed-Point Numeric Types (DECIMAL)
    
    Vector Data Type
    
    SQL Catalog
    SQL Catalog
    
    SQL Statement Categories
    
    Data Definition Language (DDL)
    Data Definition Language (DDL)
    
    CREATE DATABASE
    
    CREATE INDEX
    
    CREATE INDEX...USING IVFFLAT
    
    CREATE TABLE
    
    CREATE TABLE AS SELECT
    
    CREATE EXTERNAL TABLE
    
    CREATE PITR
    
    CREATE PUBLICATION
    
    CREATE SEQUENCE
    
    CREATE STAGE
    
    CREATE...FROM...PUBLICATION...
    
    CREATE VIEW
    
    CREATE FUNCTION...LANGUAGE SQL AS
    
    CREATE FUNCTION...LANGUAGE PYTHON AS
    
    CREATE OR REPLACE VIEW
    
    CREATE SOURCE
    
    CREATE DYNAMIC TABLE
    
    CREATE SNAPSHOT
    
    ALTER TABLE
    
    ALTER TABLE ... ALTER REINDEX
    
    ALTER PITR
    
    ALTER PUBLICATION
    
    ALTER SEQUENCE
    
    ALTER STAGE
    
    ALTER VIEW
    
    DROP DATABASE
    
    DROP INDEX
    
    DROP TABLE
    
    DROP PITR
    
    DROP PUBLICATION
    
    DROP SEQUENCE
    
    DROP STAGE
    
    DROP SNAPSHOT
    
    DROP VIEW
    
    DROP FUNCTION
    
    TRUNCATE TABLE
    
    RENAME TABLE
    
    RESTORE PITR
    
    RESTORE SNAPSHOT
    
    PARTITION
    
    Data Manipulation Language (DML)
    Data Manipulation Language (DML)
    
    INSERT
    
    INSERT INTO SELECT
    
    DELETE
    
    UPDATE
    
    LOAD DATA INFILE
    
    LOAD DATA INLINE
    
    UPSERT
    UPSERT
    
    UPSERT Overview
    
    INSERT ON DUPLICATE KEY UPDATE
    
    INSERT IGNORE
    
    REPLACE
    
    Information Functions
    Information Functions
    
    LAST_QUERY_ID()
    
    LAST_INSERT_ID()
    
    Data Query Language (DQL)
    Data Query Language (DQL)
    
    SELECT
    
    SUBQUERY
    SUBQUERY
    
    SUBQUERY Overview
    
    Derived Tables
    
    Subqueries with Comparison Operators
    
    SUBQUERY with ANY or SOME
    
    SUBQUERY with ALL
    
    SUBQUERY with EXISTS
    
    SUBQUERY with IN
    
    JOIN
    JOIN
    
    JOIN verview
    
    INNER JOIN
    
    LEFT JOIN
    
    RIGHT JOIN
    
    FULL JOIN
    
    OUTER JOIN
    
    NATURAL JOIN
    
    With CTE
    
    Union Queries
    Union Queries
    
    Union Queries Overview
    
    UNION
    
    INTERSECT
    
    MINUS
    
    Data Control Language (DCL)
    Data Control Language (DCL)
    
    CREATE ACCOUNT
    
    CREATE ROLE
    
    CREATE USER
    
    ALTER ACCOUNT
    
    ALTER USER
    
    DROP ACCOUNT
    
    DROP USER
    
    DROP ROLE
    
    GRANT
    
    REVOKE
    
    Others
    Others
    
    SHOW
    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 PITR
    
    SHOW ROLES
    
    SHOW SEQUENCES
    
    SHOW SNAPSHOTS
    
    SHOW STAGES
    
    SHOW SUBSCRIPTIONS
    
    SHOW VARIABLES
    
    SET
    SET
    
    SET ROLE
    
    USE
    USE
    
    USE DATABASE
    
    KILL
    
    Prepared
    Prepared
    
    PREPARE
    
    EXECUTE
    
    DEALLOCATE
    
    Explain
    Explain
    
    Explain
    
    Explain 输出格式
    
    Explain Analyze
    
    Functions and Operators
    Functions and Operators
    
    Operators
    Operators
    
    INTERVAL
    
    Operators
    Operators
    
    Operators Overview
    
    Operator Precedence
    
    Arithmetic Operators
    Arithmetic Operators
    
    Arithmetic Operators Overview
    
    %,MOD
    
    *
    
    +
    
    -
    
    -
    
    /
    
    DIV
    
    Assignment Operators
    Assignment Operators
    
    Assignment Operators Overview
    
    =
    
    Bitwise Operators
    Bitwise Operators
    
    Bitwise Operators Overview
    
    &
    
    >>
    
    <<
    
    ^
    
    |
    
    ~
    
    Cast Functions and Operators
    Cast Functions and Operators
    
    Cast Functions and Operators Overview
    
    BINARY
    
    CAST
    
    CONVERT
    
    DECODE
    
    ENCODE
    
    SERIAL
    
    SERIAL_FULL
    
    Comparison Functions and Operators
    Comparison Functions and Operators
    
    Comparison Functions and Operators Overview
    
    >
    
    >=
    
    <
    
    <>,!=
    
    <=
    
    =
    
    BETWEEN ... AND ...
    
    IN
    
    IS
    
    IS NOT
    
    IS NOT NULL
    
    IS NULL
    
    ISNULL
    
    ILIKE
    
    LIKE
    
    NOT BETWEEN ... AND ...
    
    NOT IN
    
    NOT LIKE
    
    COALESCE
    
    Control Flow Functions
    Control Flow Functions
    
    Control Flow Functions Overview
    
    CASE WHEN
    
    IF
    
    IFNULL
    
    NULLIF
    
    Logical Operators
    Logical Operators
    
    Logical Operators Overview
    
    AND,&&
    
    NOT,!
    
    OR
    
    XOR
    
    Functions
    Functions
    
    Function List
    
    Aggregate Functions
    Aggregate Functions
    
    ANY_VALUE
    
    AVG
    
    BITMAP
    
    BIT_AND
    
    BIT_OR
    
    BIT_XOR
    
    COUNT
    
    GROUP_CONCAT
    
    MAX
    
    MEDIAN
    
    MIN
    
    STDDEV_POP
    
    SUM
    
    VARIANCE
    
    VAR_POP
    
    Date and Time Functions
    Date and Time Functions
    
    CONVERT_TZ()
    
    CURDATE()
    
    CURRENT_TIMESTAMP()
    
    DATE()
    
    DATE_ADD()
    
    DATE_FORMAT()
    
    DATE_SUB()
    
    DATEDIFF()
    
    DAY()
    
    DAYOFYEAR()
    
    EXTRACT()
    
    HOUR()
    
    FROM_UNIXTIME
    
    MINUTE()
    
    MONTH()
    
    NOW()
    
    SECOND()
    
    STR_TO_DATE()
    
    SYSDATE()
    
    TIME()
    
    TIMEDIFF()
    
    TIMESTAMP()
    
    TIMESTAMPDIFF()
    
    TO_DATE()
    
    TO_DAYS()
    
    TO_SECONDS()
    
    UNIX_TIMESTAMP
    
    UTC_TIMESTAMP()
    
    WEEK()
    
    WEEKDAY()
    
    YEAR()
    
    Mathematical Functions
    Mathematical Functions
    
    ABS()
    
    ACOS()
    
    ATAN()
    
    CEIL()
    
    CEILING()
    
    COS()
    
    COT()
    
    EXP()
    
    FLOOR()
    
    LN()
    
    LOG()
    
    LOG2()
    
    LOG10()
    
    PI()
    
    POWER()
    
    ROUND()
    
    RAND()
    
    SIN()
    
    SINH()
    
    TAN()
    
    String Functions
    String Functions
    
    BIN()
    
    BIT_LENGTH()
    
    CHAR_LENGTH()
    
    CONCAT()
    
    CONCAT_WS()
    
    EMPTY()
    
    ENDSWITH()
    
    FIELD()
    
    FIND_IN_SET()
    
    FORMAT()
    
    FROM_BASE64()
    
    HEX()
    
    INSTR()
    
    LCASE()
    
    LEFT()
    
    LENGTH()
    
    LOCATE()
    
    LOWER()
    
    LPAD()
    
    LTRIM()
    
    MD5()
    
    OCT()
    
    REPEAT()
    
    REVERSE()
    
    RPAD()
    
    RTRIM()
    
    SHA1()/SHA()
    
    SHA2()
    
    SPACE()
    
    SPLIT_PART()
    
    STARTSWITH()
    
    SUBSTRING()
    
    SUBSTRING_INDEX()
    
    TO_BASE64()
    
    TRIM()
    
    LPAD()
    
    UCASE()
    
    UNHEX()
    
    UPPER()
    
    Regular Expressions
    Regular Expressions
    
    正则表达式概述
    
    NOT REGEXP
    
    REGEXP_INSTR()
    
    REGEXP_LIKE()
    
    REGEXP_REPLACE()
    
    REGEXP_SUBSTR()
    
    Vector Functions
    Vector Functions
    
    Basic Operators
    
    Mathematical Calculations
    
    CLUSTER_CENTERS()
    
    COSINE_SIMILARITY()
    
    COSINE_DISTANCE()
    
    INNER_PRODUCT()
    
    L1_NORM()
    
    L2_NORM()
    
    L2_DISTANCE()
    
    NORMALIZE_L2()
    
    SUBVECTOR()
    
    VECTOR_DIMS()
    
    Table Functions
    Table Functions
    
    GENERATE_SERIES()
    
    UNNEST()
    
    Window Functions
    Window Functions
    
    DENSE_RANK()
    
    RANK()
    
    ROW_NUMBER()
    
    JSON Functions
    JSON Functions
    
    JQ()
    
    JSON_EXTRACT()
    
    JSON_EXTRACT_FLOAT64()
    
    JSON_EXTRACT_STRING()
    
    JSON_QUOTE()
    
    JSON_ROW()
    
    JSON_UNQUOTE()
    
    TRY_JQ()
    
    Other Functions
    Other Functions
    
    LOAD_FILE
    
    SAVE_FILE
    
    SAMPLE
    
    SERIAL_EXTRACT
    
    SLEEP
    
    STAGE_LIST
    
    UUID()
    
    System Operations Functions
    System Operations Functions
    
    CURRENT_ROLE_NAME()
    
    CURRENT_ROLE()
    
    CURRENT_USER_NAME()
    
    CURRENT_USER()
    
    VERSION()
    
    PURGE_LOG()
    
    System Tables Catalog
    
    Permission Categories List
    
    Usage Limitations
    Usage Limitations
    
    MatrixOne JDBC Feature Support List
    
    MatrixOne DDL Statement Partition Support
    
    MatrixOne Load Data Support
  - FAQs
    FAQs
    
    SQL FAQs
    
    MatrixOne Intelligence FAQs
- Monitoring
  Monitoring
  - Monitoring Metrics
  - Monitoring Data
- Alerts
- Events
- Billing
  Billing
  - Recharge
  - Account Overview
  - Coupon Management
  - Revenue and Expenditure Details
  - Bill Details
  - Price Details
    Price Details
    
    Serverless Production Instance
    
    Standard Instance
  - Renewal
  - Cash Overdraft
  - Configuration Change
  - Unsubscription Policy
- Release Notes
  Release Notes
  - 2025
  - 2024
  - 2023
- Related Agreements
  Related Agreements
- Technical Support
- Glossary
MatrixOne

Overview of logical operators

Name	Description
AND,&&	Logic and
NOT,!	Logical non
OR	Logical or
XOR	Logical XOR

Made with Material for MkDocs