Skip to content

Latest commit

 

History

History
38 lines (34 loc) · 1 KB

README.md

File metadata and controls

38 lines (34 loc) · 1 KB
title category
SQL Statement Syntax of TiDB
compatibility

SQL Statement Syntax of TiDB

TiDB supports the SQL-92 standard and is compatible with MySQL grammar. Currently, TiDB supports the majority of frequently used MySQL syntax.

Table of Contents

  • TiDB SQL Syntax Diagram
  • Language Structure    - Literal Values    - Schema Object Names
    • Keywords and Reserved words
    • User-Defined Variables
    • Expression Syntax
    • Comment Syntax
  • Data Types
    • Numeric Types
    • String Types
    • Date and Time Type
    • Others
  • Functions and Operators
    • Operators
    • Built-in Functions
  • SQL Statement Syntax
    • Data Definition Statements
    • Data Manipulation Statements
    • Transactional Statements
    • Prepared SQL Statement Syntax
    • Database Administration Statements
    • Utility Statements
  • Privilege Management
  • The Proprietary System Variables and Syntax in TiDB
  • Others
    • SQL Modes