TiDB supports the SQL-92 standard and is compatible with MySQL. To help you easily get started with TiDB, TiDB user guide mainly inherits the MySQL document structure with some TiDB specific changes.
- TiDB Server Administration
- The TiDB Server
- The TiDB Data Directory
- The TiDB System Database
- The Proprietary System Variables and Syntax in TiDB
- TiDB Server Logs
- Security
- The TiDB Access Privilege System
- TiDB User Account Management
- Using Secure Connections
- Optimization
- Language Structure
- Literal Values
- Schema Object Names
- Keywords and Reserved words
- User-Defined Variables
- Expression Syntax
- Comment Syntax
- Globalization
- Character Set Support
- Character Set Configuration
- MySQL Server Time Zone Support
- Data Types
- Numeric Types
- Date and Time Types
- String Types
- Extensions for Spatial Data
- The JSON Data Type
- Data Type Default Values
- Data Type Storage Requirements
- Choosing the Right Type for a Column
- Using Data Types from Other Database Engines
- Functions and Operators
- Function and Operator Reference
- Type Conversion in Expression Evaluation
- Operators
- Control Flow Functions
- String Functions
- Numeric Functions and Operators
- Date and Time Functions
- Cast Functions and Operators
- Bit Functions and Operators
- Encryption and Compression Functions
- Information Functions
- JSON Functions
- Functions Used with Global Transaction IDs
- Aggregate (GROUP BY) Functions
- Miscellaneous Functions
- Precision Math
- SQL Statement Syntax
- Data Definition Statements
- Data Manipulation Statements
- Transactions
- Replication Statements
- Prepared SQL Statement Syntax
- Compound-Statement Syntax
- Database Administration Statements
- Utility Statements
- TiDB SQL Syntax Diagram
- Document Store
- Connectors and APIs
- Troubleshooting