我的书签
添加书签
移除书签Control Flow Functions
TiDB supports all of the control flow functions available in MySQL 5.7.
| Name | Description |
|---|---|
| CASE | Case operator |
| IF() | If/else construct |
| IFNULL() | Null if/else construct |
| NULLIF() | Return NULL if expr1 = expr2 |
Control Flow Functions
- SUMMARY
- About TiDB
- Quick Start
- Develop
- Deploy
- Migrate
- Overview
- Migration Tools
- Import Best Practices
- Migration Scenarios
- Migrate from Aurora
- Migrate Small Datasets from MySQL
- Migrate Large Datasets from MySQL
- Migrate and Merge MySQL Shards of Small Datasets
- Migrate and Merge MySQL Shards of Large Datasets
- Migrate from CSV Files
- Migrate from SQL Files
- Migrate from Parquet Files
- Migrate from One TiDB Cluster to Another TiDB Cluster
- Migrate from TiDB to MySQL-compatible Databases
- Advanced Migration
- Integrate
- Maintain
- Monitor and Alert
- Troubleshoot
- Performance Tuning
- Tutorials
- TiDB Tools
- Overview
- Use Cases
- Download
- TiUP
- Documentation Map
- Overview
- Terminology and Concepts
- Manage TiUP Components
- FAQ
- Troubleshooting Guide
- Command Reference
- Overview
- TiUP Commands
- TiUP Cluster Commands
- Overview
- tiup cluster audit
- tiup cluster audit cleanup
- tiup cluster check
- tiup cluster clean
- tiup cluster deploy
- tiup cluster destroy
- tiup cluster disable
- tiup cluster display
- tiup cluster edit-config
- tiup cluster enable
- tiup cluster help
- tiup cluster import
- tiup cluster list
- tiup cluster meta backup
- tiup cluster meta restore
- tiup cluster patch
- tiup cluster prune
- tiup cluster reload
- tiup cluster rename
- tiup cluster replay
- tiup cluster restart
- tiup cluster scale-in
- tiup cluster scale-out
- tiup cluster start
- tiup cluster stop
- tiup cluster template
- tiup cluster upgrade
- TiUP DM Commands
- Overview
- tiup dm audit
- tiup dm deploy
- tiup dm destroy
- tiup dm disable
- tiup dm display
- tiup dm edit-config
- tiup dm enable
- tiup dm help
- tiup dm import
- tiup dm list
- tiup dm patch
- tiup dm prune
- tiup dm reload
- tiup dm replay
- tiup dm restart
- tiup dm scale-in
- tiup dm scale-out
- tiup dm start
- tiup dm stop
- tiup dm template
- tiup dm upgrade
- TiDB Cluster Topology Reference
- DM Cluster Topology Reference
- Mirror Reference Guide
- TiUP Components
- TiDB Operator
- TiDB Data Migration
- About TiDB Data Migration
- Architecture
- Quick Start
- Best Practices
- Deploy a DM cluster
- Tutorials
- Advanced Tutorials
- Maintain
- Reference
- TiDB Lightning
- Dumpling
- TiCDC
- Overview
- Deploy and Maintain
- Changefeed
- Monitor and Alert
- Reference
- Troubleshoot
- FAQs
- Glossary
- TiDB Binlog
- PingCAP Clinic Diagnostic Service
- TiSpark
- sync-diff-inspector
- Reference
- Cluster Architecture
- TiKV
- TiFlash
- Overview
- Create TiFlash Replicas
- Use TiDB to Read TiFlash Replicas
- Use TiSpark to Read TiFlash Replicas
- Use MPP Mode
- Use FastScan
- Disaggregated Storage and Compute Architecture and S3 Support
- Supported Push-down Calculations
- TiFlash Query Result Materialization
- TiFlash Late Materialization
- Spill to Disk
- Data Validation
- Compatibility
- System Variables
- Configuration File Parameters
- CLI
- Command Line Flags
- Key Monitoring Metrics
- Security
- Privileges
- SQL
- SQL Language Structure and Syntax
- SQL Statements
- ADD COLUMN
- ADD INDEX
- ADMIN
- ADMIN CANCEL DDL
- ADMIN CHECKSUM TABLE
- ADMIN CHECK [TABLE|INDEX]
- ADMIN CLEANUP
- ADMIN RECOVER INDEX
- ADMIN SHOW DDL [JOBS|JOB QUERIES]
- ADMIN SHOW TELEMETRY
- ALTER DATABASE
- ALTER INDEX
- ALTER INSTANCE
- ALTER PLACEMENT POLICY
- ALTER RESOURCE GROUP
- ALTER TABLE
- ALTER TABLE COMPACT
- ALTER USER
- ANALYZE TABLE
- BACKUP
- BATCH
- BEGIN
- CALIBRATE RESOURCE
- CHANGE COLUMN
- COMMIT
- CHANGE DRAINER
- CHANGE PUMP
- CREATE [GLOBAL|SESSION] BINDING
- CREATE DATABASE
- CREATE INDEX
- CREATE PLACEMENT POLICY
- CREATE RESOURCE GROUP
- CREATE ROLE
- CREATE SEQUENCE
- CREATE TABLE LIKE
- CREATE TABLE
- CREATE USER
- CREATE VIEW
- DEALLOCATE
- DELETE
- DESC
- DESCRIBE
- DO
- DROP [GLOBAL|SESSION] BINDING
- DROP COLUMN
- DROP DATABASE
- DROP INDEX
- DROP PLACEMENT POLICY
- DROP RESOURCE GROUP
- DROP ROLE
- DROP SEQUENCE
- DROP STATS
- DROP TABLE
- DROP USER
- DROP VIEW
- EXECUTE
- EXPLAIN ANALYZE
- EXPLAIN
- FLASHBACK CLUSTER
- FLASHBACK DATABASE
- FLASHBACK TABLE
- FLUSH PRIVILEGES
- FLUSH STATUS
- FLUSH TABLES
- GRANT
- GRANT
- INSERT
- KILL [TIDB]
- LOAD DATA
- LOAD STATS
- LOCK STATS
- LOCK TABLES andUNLOCK TABLES
- MODIFY COLUMN
- PREPARE
- RECOVER TABLE
- RENAME USER
- RENAME INDEX
- RENAME TABLE
- REPLACE
- RESTORE
- REVOKE
- REVOKE
- ROLLBACK
- SAVEPOINT
- SELECT
- SET DEFAULT ROLE
- SET [NAMES|CHARACTER SET]
- SET PASSWORD
- SET RESOURCE GROUP
- SET ROLE
- SET TRANSACTION
- SET [GLOBAL|SESSION]
- SHOW ANALYZE STATUS
- SHOW [BACKUPS|RESTORES]
- SHOW [GLOBAL|SESSION] BINDINGS
- SHOW BUILTINS
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW [FULL] COLUMNS FROM
- SHOW CONFIG
- SHOW CREATE DATABASE
- SHOW CREATE PLACEMENT POLICY
- SHOW CREATE RESOURCE GROUP
- SHOW CREATE SEQUENCE
- SHOW CREATE TABLE
- SHOW CREATE USER
- SHOW DATABASES
- SHOW DRAINER STATUS
- SHOW ENGINES
- SHOW ERRORS
- SHOW [FULL] FIELDS FROM
- SHOW GRANTS
- SHOW INDEXES [FROM|IN]
- SHOW MASTER STATUS
- SHOW PLACEMENT
- SHOW PLACEMENT FOR
- SHOW PLACEMENT LABELS
- SHOW PLUGINS
- SHOW PRIVILEGES
- SHOW [FULL] PROCESSSLIST
- SHOW PROFILES
- SHOW PUMP STATUS
- SHOW SCHEMAS
- SHOW STATS_HEALTHY
- SHOW STATS_HISTOGRAMS
- SHOW STATS_LOCKED
- SHOW STATS_META
- SHOW STATUS
- SHOW TABLE NEXT_ROW_ID
- SHOW TABLE REGIONS
- SHOW TABLE STATUS
- SHOW [FULL] TABLES
- SHOW [GLOBAL|SESSION] VARIABLES
- SHOW WARNINGS
- SHUTDOWN
- SPLIT REGION
- START TRANSACTION
- TABLE
- TRACE
- TRUNCATE
- UNLOCK STATS
- UPDATE
- USE
- WITH
- 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
- Window Functions
- Miscellaneous Functions
- Precision Math
- Set Operations
- List of Expressions for Pushdown
- TiDB Specific Functions
- Comparisons between Functions and Syntax of Oracle and TiDB
- Clustered Indexes
- Constraints
- Generated Columns
- SQL Mode
- Table Attributes
- Transactions
- Views
- Partitioning
- Temporary Tables
- Cached Tables
- FOREIGN KEY Constraints
- Character Set and Collation
- Placement Rules in SQL
- System Tables
- mysql
- INFORMATION_SCHEMA
- Overview
- ANALYZE_STATUS
- CLIENT_ERRORS_SUMMARY_BY_HOST
- CLIENT_ERRORS_SUMMARY_BY_USER
- CLIENT_ERRORS_SUMMARY_GLOBAL
- CHARACTER_SETS
- CLUSTER_CONFIG
- CLUSTER_HARDWARE
- CLUSTER_INFO
- CLUSTER_LOAD
- CLUSTER_LOG
- CLUSTER_SYSTEMINFO
- COLLATIONS
- COLLATION_CHARACTER_SET_APPLICABILITY
- COLUMNS
- DATA_LOCK_WAITS
- DDL_JOBS
- DEADLOCKS
- ENGINES
- INSPECTION_RESULT
- INSPECTION_RULES
- INSPECTION_SUMMARY
- KEY_COLUMN_USAGE
- MEMORY_USAGE
- MEMORY_USAGE_OPS_HISTORY
- METRICS_SUMMARY
- METRICS_TABLES
- PARTITIONS
- PLACEMENT_POLICIES
- PROCESSLIST
- REFERENTIAL_CONSTRAINTS
- RESOURCE_GROUPS
- SCHEMATA
- SEQUENCES
- SESSION_VARIABLES
- SLOW_QUERY
- STATISTICS
- TABLES
- TABLE_CONSTRAINTS
- TABLE_STORAGE_STATS
- TIDB_HOT_REGIONS
- TIDB_HOT_REGIONS_HISTORY
- TIDB_INDEXES
- TIDB_SERVERS_INFO
- TIDB_TRX
- TIFLASH_REPLICA
- TIFLASH_SEGMENTS
- TIFLASH_TABLES
- TIKV_REGION_PEERS
- TIKV_REGION_STATUS
- TIKV_STORE_STATUS
- USER_ATTRIBUTES
- USER_PRIVILEGES
- VARIABLES_INFO
- VIEWS
- METRICS_SCHEMA
- Metadata Lock
- UI
- Telemetry
- Error Codes
- Table Filter
- Schedule Replicas by Topology Labels
- URI Formats of External Storage Services
- Internal Components
- FAQs
- Release Notes
- Glossary
暂无相关搜索结果！
本文档使用 BookStack 构建
