tencent cloud

All product documents
TDSQL-C for MySQL
DocumentationTDSQL-C for MySQLOperation GuideRead-Only Analysis EngineFeature Limits and CompatibilityDescription of Functions and OperatorsDescription of Supported Mathematical Operation Functions
Description of Supported Mathematical Operation Functions
Download PDF
Last updated: 2025-01-09 14:21:30
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.
Was this page helpful?
You can also Contact Sales or Submit a Ticket for help.
Yes
No

Feedback

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
Hong Kong, China
+852 800 906 020 (Toll Free)
United States
+1 844 606 0804 (Toll Free)
United Kingdom
+44 808 196 4551 (Toll Free)
Canada
+1 888 605 7930 (Toll Free)
Australia
+61 1300 986 386 (Toll Free)
EdgeOne hotline
+852 300 80699
More local hotlines coming soon