tencent cloud

TDSQL-C for MySQL

DocumentaçãoTDSQL-C for MySQL

Description of Supported Comparison Operations

Download
Modo Foco
Tamanho da Fonte
Última atualização: 2025-01-09 14:17:00
Currently, the read-only analysis engine supports most of MySQL's comparison operation logic, but there are still limitations and incompatibilities in certain scenarios. This document introduces supported comparison operations in the read-only analysis engine and enumerates type restrictions on input parameters. Input parameters and usage methods not mentioned in the document are not supported.

Supported Comparison Operation Types

Greater than or Equal to (>=)

Syntax: op1 >= op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.

Less than or Equal to (<=)

Syntax: op1 <= op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.

Equal to (=)

Syntax: op1 = op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.

Not Equal to (!=)

Syntax: op1 != op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.

Less than (<)

Syntax: op1 < op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.

Greater than (>)

Syntax: op1 > op2 Supported value types for op1: int, bigint, float, double, decimal, char, varchar, date, and datetime. Supported value types for op2: int, bigint, float, double, decimal, char, varchar, date, and datetime.
Próximo: Service Level Agreement

Ajuda e Suporte

Esta página foi útil?

comentários