TiDB Basic Features
This document introduces the basic features of TiDB.
Date and time types:
- Arithmetic operators, bit operators, comparison operators, logical operators, date and time operators, and so on.
Character sets and collations
- Control flow functions, string functions, date and time functions, bit functions, data type conversion functions, data encryption and decryption functions, compression and decompression functions, information functions, JSON functions, aggregation functions, window functions, and so on.
Fully supports standard Data Definition Language (DDL) statements, such as
TRUNCATE, and so on.
Fully supports standard Data Manipulation Language (DML) statements, such as
LOAD DATA, and so on.
Fully supports standard transactional and locking statements, such as
SET TRANSACTION, and so on.
Fully supports standard database administration statements, such as
SET, and so on.
Fully supports standard utility statements, such as
USE, and so on.
Fully supports the
Fully supports the standard
LEFT OUTER JOINand
RIGHT OUTER JOINSQL statements.
Fully supports the standard SQL table and column aliases.
- Supports Range partitioning
- Supports Hash partitioning
- Supports general views
- Supports non-empty constraints
- Supports primary key constraints
- Supports unique constraints
- Supports privilege management based on RBAC (role-based access control)
- Supports password management
- Supports communication and data encryption
- Supports IP allowlist
- Supports audit
- Supports fast backup
- Supports data migration from MySQL to TiDB using tools
- Supports deploying and maintaining TiDB using tools