- Docs Home
- About TiDB Cloud
- Get Started
- Develop Applications
- Overview
- Quick Start
- Connect to TiDB Cloud
- Third-Party Support
- Development Reference
- Design Database Schema
- Write Data
- Read Data
- Transaction
- Optimize
- Troubleshoot
- Development Guidelines
- Bookshop Example Application
- Manage Cluster
- Plan Your Cluster
- Manage TiDB Serverless Clusters
- Create a TiDB Serverless Cluster
- Connect to Your TiDB Serverless Cluster
- Branch (Beta)
- Manage Spending Limit
- Back Up and Restore TiDB Serverless Data
- Manage TiDB Dedicated Clusters
- Create a TiDB Dedicated Cluster
- Connect to Your TiDB Dedicated Cluster
- Scale a TiDB Dedicated Cluster
- Back Up and Restore TiDB Dedicated Data
- Pause or Resume a TiDB Dedicated Cluster
- Configure Maintenance Window
- Use an HTAP Cluster with TiFlash
- Monitor and Alert
- Tune Performance
- Overview
- Analyze Performance
- SQL Tuning
- Overview
- Understanding the Query Execution Plan
- SQL Optimization Process
- Overview
- Logic Optimization
- Physical Optimization
- Prepared Execution Plan Cache
- Non-Prepared Execution Plan Cache
- Control Execution Plans
- TiKV Follower Read
- Coprocessor Cache
- Garbage Collection (GC)
- Tune TiFlash Performance
- Upgrade a TiDB Cluster
- Delete a TiDB Cluster
- Migrate or Import Data
- Overview
- Migrate Data into TiDB Cloud
- Migrate Existing and Incremental Data Using Data Migration
- Migrate Incremental Data Using Data Migration
- Migrate and Merge MySQL Shards of Large Datasets
- Migrate from On-Premises TiDB to TiDB Cloud
- Migrate from MySQL-Compatible Databases Using AWS DMS
- Migrate from Amazon RDS for Oracle Using AWS DMS
- Import Data into TiDB Cloud
- Reference
- Explore Data
- Data Service (Beta)
- Stream Data
- Security
- Identity Access Control
- Network Access Control
- Data Access Control
- Database Access Control
- Audit Management
- Billing
- API
- Integrations
- Reference
- TiDB Cluster Architecture
- TiDB Dedicated Limitations and Quotas
- TiDB Serverless Limitations
- Limited SQL Features on TiDB Cloud
- TiDB Limitations
- Benchmarks
- SQL
- Explore SQL with TiDB
- SQL Language Structure and Syntax
- SQL Statements
ADD COLUMNADD INDEXADMINADMIN CANCEL DDLADMIN CHECKSUM TABLEADMIN CHECK [TABLE|INDEX]ADMIN CLEANUP INDEXADMIN PAUSE DDLADMIN RECOVER INDEXADMIN RESUME DDLADMIN SHOW DDL [JOBS|JOB QUERIES]ALTER DATABASEALTER INDEXALTER INSTANCEALTER PLACEMENT POLICYALTER RESOURCE GROUPALTER TABLEALTER TABLE COMPACTALTER USERANALYZE TABLEBACKUPBATCHBEGINCHANGE COLUMNCOMMITCREATE [GLOBAL|SESSION] BINDINGCREATE DATABASECREATE INDEXCREATE PLACEMENT POLICYCREATE RESOURCE GROUPCREATE ROLECREATE SEQUENCECREATE TABLE LIKECREATE TABLECREATE USERCREATE VIEWDEALLOCATEDELETEDESCDESCRIBEDODROP [GLOBAL|SESSION] BINDINGDROP COLUMNDROP DATABASEDROP INDEXDROP PLACEMENT POLICYDROP RESOURCE GROUPDROP ROLEDROP SEQUENCEDROP STATSDROP TABLEDROP USERDROP VIEWEXECUTEEXPLAIN ANALYZEEXPLAINFLASHBACK CLUSTER TO TIMESTAMPFLASHBACK DATABASEFLASHBACK TABLEFLUSH PRIVILEGESFLUSH STATUSFLUSH TABLESGRANT <privileges>GRANT <role>INSERTKILL [TIDB]LOAD DATALOAD STATSLOCK STATSLOCK TABLESandUNLOCK TABLESMODIFY COLUMNPREPAREQUERY WATCHRECOVER TABLERENAME INDEXRENAME TABLERENAME USERREPLACERESTOREREVOKE <privileges>REVOKE <role>ROLLBACKSAVEPOINTSELECTSET DEFAULT ROLESET [NAMES|CHARACTER SET]SET PASSWORDSET RESOURCE GROUPSET ROLESET TRANSACTIONSET [GLOBAL|SESSION] <variable>SHOW ANALYZE STATUSSHOW [BACKUPS|RESTORES]SHOW [GLOBAL|SESSION] BINDINGSSHOW BUILTINSSHOW CHARACTER SETSHOW COLLATIONSHOW [FULL] COLUMNS FROMSHOW CREATE DATABASESHOW CREATE PLACEMENT POLICYSHOW CREATE RESOURCE GROUPSHOW CREATE SEQUENCESHOW CREATE TABLESHOW CREATE USERSHOW DATABASESSHOW ENGINESSHOW ERRORSSHOW [FULL] FIELDS FROMSHOW GRANTSSHOW INDEX [FROM|IN]SHOW INDEXES [FROM|IN]SHOW KEYS [FROM|IN]SHOW MASTER STATUSSHOW PLACEMENTSHOW PLACEMENT FORSHOW PLACEMENT LABELSSHOW PLUGINSSHOW PRIVILEGESSHOW [FULL] PROCESSSLISTSHOW PROFILESSHOW SCHEMASSHOW STATS_HEALTHYSHOW STATS_HISTOGRAMSSHOW STATS_LOCKEDSHOW STATS_METASHOW STATUSSHOW TABLE NEXT_ROW_IDSHOW TABLE REGIONSSHOW TABLE STATUSSHOW [FULL] TABLESSHOW [GLOBAL|SESSION] VARIABLESSHOW WARNINGSSPLIT REGIONSTART TRANSACTIONTABLETRACETRUNCATEUNLOCK STATSUPDATEUSEWITH
- Data Types
- Functions and Operators
- Overview
- Type Conversion in Expression Evaluation
- Operators
- Control Flow Functions
- String Functions
- Numeric Functions and Operators
- Date and Time Functions
- Bit Functions and Operators
- Cast Functions and Operators
- Encryption and Compression Functions
- Locking Functions
- Information Functions
- JSON Functions
- Aggregate (GROUP BY) Functions
- GROUP BY Modifiers
- Window Functions
- Miscellaneous Functions
- Precision Math
- Set Operations
- List of Expressions for Pushdown
- TiDB Specific Functions
- Clustered Indexes
- Constraints
- Generated Columns
- SQL Mode
- Table Attributes
- Transactions
- Views
- Partitioning
- Temporary Tables
- Cached Tables
- FOREIGN KEY Constraints
- Character Set and Collation
- Read Historical Data
- Placement Rules in SQL
- System Tables
mysql- INFORMATION_SCHEMA
- Overview
ANALYZE_STATUSCHECK_CONSTRAINTSCLIENT_ERRORS_SUMMARY_BY_HOSTCLIENT_ERRORS_SUMMARY_BY_USERCLIENT_ERRORS_SUMMARY_GLOBALCHARACTER_SETSCLUSTER_INFOCOLLATIONSCOLLATION_CHARACTER_SET_APPLICABILITYCOLUMNSDATA_LOCK_WAITSDDL_JOBSDEADLOCKSENGINESKEY_COLUMN_USAGEMEMORY_USAGEMEMORY_USAGE_OPS_HISTORYPARTITIONSPLACEMENT_POLICIESPROCESSLISTREFERENTIAL_CONSTRAINTSRESOURCE_GROUPSRUNAWAY_WATCHESSCHEMATASEQUENCESSESSION_VARIABLESSLOW_QUERYSTATISTICSTABLESTABLE_CONSTRAINTSTABLE_STORAGE_STATSTIDB_HOT_REGIONS_HISTORYTIDB_INDEXESTIDB_SERVERS_INFOTIDB_TRXTIFLASH_REPLICATIFLASH_SEGMENTSTIFLASH_TABLESTIKV_REGION_PEERSTIKV_REGION_STATUSTIKV_STORE_STATUSUSER_ATTRIBUTESUSER_PRIVILEGESVARIABLES_INFOVIEWS
- PERFORMANCE_SCHEMA
- Metadata Lock
- Use UUIDs
- System Variables
- Storage Engines
- TiKV
- TiFlash
- CLI
- Table Filter
- Resource Control
- TiDB Backend Task Distributed Execution Framework
- TiDB Global Sort
- DDL Execution Principles and Best Practices
- Troubleshoot Inconsistency Between Data and Indexes
- Support
- Glossary
- FAQs
- Release Notes
- Maintenance Notification