tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TDSQL-C for MySQL
    Documentation
    Download PDF

    Description of Supported Comparison Operations

    Last updated: 2025-01-09 14:17:00
    Download PDF
      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.
      Contact Us

      Contact our sales team or business advisors to help your business.

      Contact Us
      Technical Support

      Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

      Submit a Ticket
      7x24 Phone Support
      Copyright © 2013-2025 Tencent Cloud. All Rights Reserved.
      Privacy PolicyLegalCookie Policy