我的书签
添加书签
移除书签位函数和操作符
TiDB 支持使用 MySQL 5.7 中提供的所有位函数和操作符。
位函数和操作符表
| 函数和操作符名 | 功能描述 |
|---|---|
| BIT_COUNT() | 返回参数二进制表示中为 1 的个数 |
| & | 位与 |
| ~ | 按位取反 |
| | | 位或 |
| ^ | 位亦或 |
| << | 左移 |
| >> | 右移 |
位函数和操作符
- 文档中心
- 关于 TiDB
- 快速上手
- 应用开发
- 部署标准集群
- 数据迁移
- 数据集成
- 运维操作
- 监控与告警
- 故障诊断
- 性能调优
- 教程
- TiDB 工具
- 功能概览
- 使用场景
- 工具下载
- TiUP
- 文档地图
- 概览
- 术语及核心概念
- TiUP 组件管理
- FAQ
- 故障排查
- TiUP 命令参考手册
- 命令概览
- TiUP 命令
- TiUP Cluster 命令
- TiUP Cluster 命令概览
- 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 命令
- TiUP DM 命令概览
- 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 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 集群拓扑文件配置
- DM 集群拓扑文件配置
- TiUP 镜像参考指南
- TiUP 组件文档
- TiDB Operator
- TiDB Data Migration
- TiDB Lightning
- Dumpling
- TiCDC
- TiDB Binlog
- PingCAP Clinic 诊断服务
- TiSpark
- sync-diff-inspector
- TiUniManager
- 参考指南
- 架构
- 存储引擎 TiKV
- 存储引擎 TiFlash
- 系统变量
- 配置文件参数
- CLI
- 命令行参数
- 监控指标
- 安全加固
- 权限
- SQL
- SQL 语言结构和语法
- SQL 语句
- ADD COLUMN
- ADD INDEX
- ADMIN
- ADMIN CANCEL DDL
- ADMIN CHECKSUM TABLE
- ADMIN CHECK [TABLE|INDEX]
- ADMIN CLEANUP
- ADMIN RECOVER INDEX
- ADMIN SHOW DDL [JOBS|QUERIES]
- ADMIN SHOW TELEMETRY
- ALTER DATABASE
- ALTER INDEX
- ALTER INSTANCE
- ALTER PLACEMENT POLICY
- ALTER TABLE
- ALTER TABLE COMPACT
- ALTER USER
- ANALYZE TABLE
- BACKUP
- BATCH
- BEGIN
- CHANGE COLUMN
- CHANGE DRAINER
- CHANGE PUMP
- COMMIT
- CREATE [GLOBAL|SESSION] BINDING
- CREATE DATABASE
- CREATE INDEX
- CREATE PLACEMENT POLICY
- 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 ROLE
- DROP SEQUENCE
- DROP STATS
- DROP TABLE
- DROP USER
- DROP VIEW
- EXECUTE
- EXPLAIN ANALYZE
- EXPLAIN
- FLASHBACK CLUSTER TO TIMESTAMP
- FLASHBACK DATABASE
- FLASHBACK TABLE
- FLUSH PRIVILEGES
- FLUSH STATUS
- FLUSH TABLES
- GRANT <privileges>
- GRANT <role>
- INSERT
- KILL [TIDB]
- LOAD DATA
- LOAD STATS
- LOCK STATS
- LOCK TABLES 和UNLOCK TABLES
- MODIFY COLUMN
- PREPARE
- RECOVER TABLE
- RENAME INDEX
- RENAME TABLE
- RENAME USER
- REPLACE
- RESTORE
- REVOKE <privileges>
- REVOKE <role>
- ROLLBACK
- SAVEPOINT
- SELECT
- SET DEFAULT ROLE
- SET [NAMES|CHARACTER SET]
- SET PASSWORD
- SET ROLE
- SET TRANSACTION
- SET [GLOBAL|SESSION] <variable>
- SHOW [BACKUPS|RESTORES]
- SHOW ANALYZE STATUS
- SHOW [GLOBAL|SESSION] BINDINGS
- SHOW BUILTINS
- SHOW CHARACTER SET
- SHOW COLLATION
- SHOW [FULL] COLUMNS FROM
- SHOW CONFIG
- SHOW CREATE PLACEMENT POLICY
- SHOW CREATE SEQUENCE
- SHOW CREATE TABLE
- SHOW CREATE DATABASE
- SHOW CREATE USER
- SHOW DATABASES
- SHOW DRAINER STATUS
- SHOW ENGINES
- SHOW ERRORS
- SHOW [FULL] FIELDS FROM
- SHOW GRANTS
- SHOW INDEX [FROM|IN]
- SHOW INDEXES [FROM|IN]
- SHOW KEYS [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
- 数据类型
- 函数与操作符
- 聚簇索引
- 约束
- 生成列
- SQL 模式
- 表属性
- 事务
- 视图
- 分区表
- 临时表
- 缓存表
- 字符集和排序
- Placement Rules in SQL
- 系统表
- 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
- 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
- 元数据锁
- UI
- 遥测
- 错误码
- 通过拓扑 label 进行副本调度
- 版本发布历史
- 术语表
暂无相关搜索结果！
本文档使用 BookStack 构建
