Documentation
- Introduction
- Concepts
- Architecture
- Key Features
- Horizontal Scalability
- MySQL Compatible Syntax
- Replicate from and to MySQL
- Distributed Transactions with Strong Consistency
- Cloud Native Architecture
- Minimize ETL with HTAP
- Fault Tolerance & Recovery with Raft
- Automatic Rebalancing
- Deployment and Orchestration with Ansible, Kubernetes, Docker
- JSON Support
- Spark Integration
- Read Historical Data without Restoring from Backup
- Fast Import and Restore of Data
- Hybrid of Column and Row Storage
- SQL Plan Management
- Open Source
- Online Schema Changes
- How-to
- Reference
- SQL
- Supported Client Drivers
- MySQL Compatibility
- SQL Statements
- Data Types
- Constraints
- Functions and Operators
- Function and Operator Reference
- 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
- Information Functions
- JSON Functions
- Aggregate (GROUP BY) Functions
- Miscellaneous Functions
- Precision Math
- SQL Language Structure
- Generated Columns
- Transactions
- Performance
- TiDB System Database
- Information Schema
- TiSpark
- Configuration
- Tools
- Roadmap
- Adopters
- SQL
- FAQs
- Releases
Bit Functions and Operators
In TiDB, the usage of bit functions and operators is similar to MySQL. See Bit Functions and Operators.
Bit functions and operators
| Name | Description |
|---|---|
BIT_COUNT() |
Return the number of bits that are set as 1 |
| & | Bitwise AND |
| ~ | Bitwise inversion |
| | | Bitwise OR |
| 0 | Bitwise XOR |
| << | Left shift |
| >> | Right shift |
"Bit Functions and Operators"
was last updated
Jul 26 2018:
*: add summary metadata to all docs files for SEO (#550) (c1e613d)