- Why TiDB Cloud
- Get Started
- Key Concepts
- Select Your Plan
- Manage TiDB Cloud Resources and Projects
- Manage {{{ .starter }}} Instances
- Create a {{{ .starter }}} Instance
- Connect to Your {{{ .starter }}} Instance
- Branch
- Manage Spending Limit
- Back Up and Restore TiDB Cloud Data
- Export Data from TiDB Cloud
- Use TiFlash for HTAP
- 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 the TiDB Version
- Delete a {{{ .starter }}} Instance
- Migrate or Import Data
- Overview
- Migrate Data into TiDB Cloud
- Import Data into TiDB Cloud
- Reference
- Explore Data
- Data Service
- Security
- Security Overview
- Identity Access Control
- Network Access Control
- Audit Management
- Billing
- Integrations
- Airbyte
- Amazon AppFlow
- AWS Lambda
- Cloudflare
- dbt
- Gitpod
- n8n
- Netlify
- ProxySQL
- Terraform
- Vercel
- Zapier
- SQL Reference
- Explore SQL with TiDB
- SQL Language Structure and Syntax
- SQL Statements
- Overview
ADMINADMIN CANCEL DDLADMIN CHECKSUM TABLEADMIN CHECK [TABLE|INDEX]ADMIN CLEANUP INDEXADMIN PAUSE DDLADMIN RECOVER INDEXADMIN RESUME DDLADMIN SHOW DDL [JOBS|JOB QUERIES]ALTER DATABASEALTER INSTANCEALTER SEQUENCEALTER TABLEALTER USERANALYZE TABLEBATCHBEGINCANCEL IMPORT JOBCOMMITCREATE [GLOBAL|SESSION] BINDINGCREATE DATABASECREATE INDEXCREATE ROLECREATE SEQUENCECREATE TABLE LIKECREATE TABLECREATE USERCREATE VIEWDEALLOCATEDELETEDESCDESCRIBEDODROP [GLOBAL|SESSION] BINDINGDROP DATABASEDROP ROLEDROP SEQUENCEDROP STATSDROP TABLEDROP USERDROP VIEWEXECUTEEXPLAIN ANALYZEEXPLAINFLASHBACK CLUSTERFLASHBACK DATABASEFLASHBACK TABLEFLUSH PRIVILEGESFLUSH STATUSFLUSH TABLESGRANT <privileges>GRANT <role>IMPORT INTOINSERTKILL [TIDB]LOAD DATALOCK STATSLOCK TABLESandUNLOCK TABLESPREPARERECOVER TABLERENAME TABLERENAME USERREPLACEREVOKE <privileges>REVOKE <role>ROLLBACKSAVEPOINTSELECTSET DEFAULT ROLESET [NAMES|CHARACTER SET]SET PASSWORDSET ROLESET TRANSACTIONSET [GLOBAL|SESSION] <variable>SHOW ANALYZE STATUSSHOW [GLOBAL|SESSION] BINDINGSSHOW BUILTINSSHOW CHARACTER SETSHOW COLLATIONSHOW COLUMN_STATS_USAGESHOW COLUMNS FROMSHOW CREATE DATABASESHOW CREATE SEQUENCESHOW CREATE TABLESHOW CREATE USERSHOW DATABASESSHOW ENGINESSHOW ERRORSSHOW FIELDS FROMSHOW GRANTSSHOW IMPORT JOBSHOW INDEXES [FROM|IN]SHOW MASTER STATUSSHOW PRIVILEGESSHOW PROCESSLISTSHOW PROFILESSHOW SCHEMASSHOW STATS_BUCKETSSHOW STATS_HEALTHYSHOW STATS_HISTOGRAMSSHOW STATS_LOCKEDSHOW STATS_METASHOW STATS_TOPNSHOW STATUSSHOW TABLE NEXT_ROW_IDSHOW TABLE STATUSSHOW TABLESSHOW [GLOBAL|SESSION] VARIABLESSHOW WARNINGSSTART 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
- Sequence Functions
- List of Expressions for Pushdown
- TiDB Specific Functions
- Clustered Indexes
- Global 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
- System Tables
mysqlSchema- INFORMATION_SCHEMA
- Overview
ANALYZE_STATUSCHECK_CONSTRAINTSCLIENT_ERRORS_SUMMARY_BY_HOSTCLIENT_ERRORS_SUMMARY_BY_USERCLIENT_ERRORS_SUMMARY_GLOBALCHARACTER_SETSCOLLATIONSCOLLATION_CHARACTER_SET_APPLICABILITYCOLUMNSDATA_LOCK_WAITSDDL_JOBSDEADLOCKSENGINESKEYWORDSKEY_COLUMN_USAGEMEMORY_USAGEMEMORY_USAGE_OPS_HISTORYPARTITIONSPROCESSLISTREFERENTIAL_CONSTRAINTSSCHEMATASEQUENCESSESSION_VARIABLESSTATISTICSTABLESTABLE_CONSTRAINTSTABLE_STORAGE_STATSTIDB_CHECK_CONSTRAINTSTIDB_INDEXESTIDB_INDEX_USAGETIDB_TRXTIFLASH_REPLICATIFLASH_SEGMENTSTIFLASH_TABLESUSER_ATTRIBUTESUSER_PRIVILEGESVARIABLES_INFOVIEWS
- PERFORMANCE_SCHEMA
- SYS
- Metadata Lock
- TiDB Accelerated Table Creation
- CLI Reference
- Overview
- auth
- serverless
- completion
- config
- project
- upgrade
- help
- General Reference
- TiDB Classic Architecture
- TiDB X Architecture
- Storage Engines
- TiKV
- TiFlash
- TiDB Cloud Partner Web Console
- {{{ .starter }}} and Essential Limitations
- Limited SQL Features on TiDB Cloud
- TiDB Limitations
- System Variables
- Server Status Variables
- Table Filter
- URI Formats of External Storage Services
- Troubleshoot Inconsistency Between Data and Indexes
- Notifications
- Project API Migration Guide for {{{ .starter }}} and Essential
- Support Plan
- Connected Care Overview
- Connected Care Details
- Connected Care Support Service Features
- Connected: AI Chat in IM
- Connected: IM Ticket Creation and Update Subscription
- Connected: IM Interaction for Support Tickets
- Get Support
- FAQs
- Glossary