tencent cloud

PrevNext

Feedback

search by keyword

Recent Pages

Documentation
TDSQL-C for MySQL
    Documentation
    Download PDF

    Description of Supported Mathematical Operation Functions

    Last updated: 2025-01-09 14:21:30
    Download PDF
      Currently, the read-only analysis engine supports most of MySQL's mathematical operation functions, but there are still limitations and incompatibilities in certain scenarios. This document introduces the list of supported mathematical operation functions in the read-only analysis engine, and enumerates type restrictions on input parameters. Input parameters and functions not mentioned in the document are not supported.

      Supported Types of Mathematical Operation Functions

      round Function

      Rounding function.
      Syntax: round(x) Supported value types for x: decimal.

      abs Function

      A function that calculates the absolute value.
      Syntax: abs(x) Supported value types for x: int, bigint, double, and decimal.

      floor Function

      A function that rounds a value down.
      Syntax: floor(x) Supported value types for x: int, bigint, double, and decimal.

      ceil Function

      A function that rounds a value up.
      Syntax: ceil(x) Supported value types for x: int, bigint, double, and decimal.

      ceiling Function

      A function that calculates the larger integer nearest to a value.
      Syntax: ceiling(x) Supported value types for x: int, bigint, double, and decimal.

      sqrt Function

      Square root function.
      Syntax: sqrt(x) Supported value types for x: int, bigint, double, and decimal.

      log Function

      Logarithmic function.
      Syntax: log(x) Supported value types for x: int, bigint, double, and decimal.

      log2 Function

      Logarithmic function with a base of 2.
      Syntax: log2(x) Supported value types for x: int, bigint, double, and decimal.

      log10 Function

      Logarithmic function with a base of 10.
      Syntax: log10(x) Supported value types for x: int, bigint, double, and decimal.

      ln Function

      A function that returns the natural logarithm of a number.
      Syntax: ln(x) Supported value types for x: int, bigint, double, and decimal.

      exp Function

      A function that returns e raised to the power of x.
      Syntax: exp(x) Supported value types for x: int, bigint, double, and decimal.

      pow Function

      A function that calculates x raised to the power of y.
      Syntax: pow(x, y) Supported value types for x: int, bigint, double, and decimal.
      Supported value types for y: int, bigint, double, and decimal.

      sign Function

      A function used to determine the sign of a real number.
      Syntax: sign(x) Supported value types for x: int, bigint, double, and decimal.

      radians Function

      A function that converts degrees to radians.
      Syntax: radians(x) Supported value types for x: int, bigint, double, and decimal.

      degrees Function

      A function that converts radians to degrees.
      Syntax: degrees(x) Supported value types for x: int, bigint, double, and decimal.

      conv Function

      A function that converts a number from one numeric base system to another and returns the result as a string value.
      Syntax: conv(n, from_base, to_base) Supported value types for n: int, bigint, double, and decimal. Supported value types for from_base: int, bigint, double, and decimal. Supported value types for to_base: int.

      crc32 Function

      Cyclic redundancy check function.
      Syntax: crc32(expr) Supported value types for expr: int, bigint, double, and decimal.

      greatest Function

      A function that returns the maximum value among N values.
      Syntax: greatest(value1, value2, ...) Supported value types for value1: int, bigint, double, and decimal. Supported value types for value2: int, bigint, double, and decimal.

      least Function

      A function that returns the minimum value among N values.
      Syntax: least(value1, value2, ...) Supported value types for value1: int, bigint, double, and decimal. Supported value types for value2: int, bigint, double, and decimal.
      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