tencent cloud

TencentDB for MySQL

Description of Supported Bitwise Operations

Download
Focus Mode
Font Size
Last updated: 2025-05-09 11:51:17
This document outlines the support for bitwise operations in the read-only analysis engine and lists the type restrictions for input parameters. Any input types or usage methods not explicitly mentioned in this document are not supported.

Supported Bitwise Operations

& Bitwise AND

Syntax: value1 & value2
Supported data types for value1: int, bigint, double, decimal, varchar, and char.
Supported data types for value2: int, bigint, double, decimal, varchar, and char.

| Bitwise OR

Syntax: value1 | value2
Supported data types for value1: int, bigint, double, decimal, varchar, and char.
Supported data types for value2: int, bigint, double, decimal, varchar, and char.

~ Bitwise NOT

Syntax: ~value1
Supported data types for value1: int, bigint, double, decimal, varchar, and char.

^ Bitwise XOR

Syntax: value1 ^ value2
Supported data types for value1: int, bigint, double, decimal, varchar, and char.
Supported data types for value2: int, bigint, double, decimal, varchar, and char.

Help and Support

Was this page helpful?

Help us improve! Rate your documentation experience in 5 mins.

Feedback