- Docs Home
- About TiDB Cloud
- Get Started
- Develop Applications
- Overview
- Quick Start
- Connect to TiDB Cloud
- GUI Database Tools
- Choose Driver or ORM
- Java
- Go
- Python
- Node.js
- Ruby
- WordPress
- 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
- TiDB Distributed eXecution Framework (DXF)
- 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 RANGEALTER RESOURCE GROUPALTER TABLEALTER TABLE COMPACTALTER USERANALYZE TABLEBACKUPBATCHBEGINCHANGE COLUMNCOMMITCREATE BINDINGCREATE DATABASECREATE INDEXCREATE PLACEMENT POLICYCREATE RESOURCE GROUPCREATE ROLECREATE SEQUENCECREATE TABLE LIKECREATE TABLECREATE USERCREATE VIEWDEALLOCATEDELETEDESCDESCRIBEDODROP 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>INSERTKILLLOAD DATALOAD STATSLOCK STATS[LOCK|UNLOCK] TABLESMODIFY COLUMNPREPAREQUERY WATCHRECOVER TABLERENAME INDEXRENAME TABLERENAME USERREPLACERESTOREREVOKE <privileges>REVOKE <role>ROLLBACKSAVEPOINTSELECTSET DEFAULT ROLESET [NAMES|CHARACTER SET]SET PASSWORDSET RESOURCE GROUPSET ROLESET TRANSACTIONSET <variable>SHOW ANALYZE STATUSSHOW [BACKUPS|RESTORES]SHOW BINDINGSSHOW BUILTINSSHOW CHARACTER SETSHOW COLLATIONSHOW COLUMNS FROMSHOW CREATE DATABASESHOW CREATE PLACEMENT POLICYSHOW CREATE RESOURCE GROUPSHOW CREATE SEQUENCESHOW CREATE TABLESHOW CREATE USERSHOW DATABASESSHOW ENGINESSHOW ERRORSSHOW FIELDS FROMSHOW GRANTSSHOW INDEXESSHOW MASTER STATUSSHOW PLACEMENTSHOW PLACEMENT FORSHOW PLACEMENT LABELSSHOW PLUGINSSHOW PRIVILEGESSHOW PROCESSSLISTSHOW PROFILESSHOW SCHEMASSHOW STATS_HEALTHYSHOW STATS_HISTOGRAMSSHOW STATS_LOCKEDSHOW STATS_METASHOW STATUSSHOW TABLE NEXT_ROW_IDSHOW TABLE REGIONSSHOW TABLE STATUSSHOW TABLESSHOW 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
- Server Status Variables
- Storage Engines
- TiKV
- TiFlash
- CLI
- Table Filter
- Resource Control
- DDL Execution Principles and Best Practices
- Troubleshoot Inconsistency Between Data and Indexes
- Support
- Glossary
- FAQs
- Release Notes
- Maintenance Notification