TiDB supports the SQL-92 standard and is compatible with MySQL grammar. Currently, TiDB supports the majority of frequently-used MySQL syntax.
- 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
- Others
- SQL Modes