MySafeInfo

MySQL Numeric Functions

Technology 36 records updated 2026-07-17

MySQL Numeric Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/mysqlnumericfunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against mysqlnumericfunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 25 of 36 records. Click a column to sort these rows.

ID Function Description
1 ABS Returns the absolute value of a number
2 ACOS Returns the arc cosine of a number
3 ASIN Returns the arc sine of a number
4 ATAN Returns the arc tangent of one or two numbers
5 ATAN2 Returns the arc tangent of two numbers
6 AVG Returns the average value of an expression
7 CEIL Returns the smallest integer value that is >= to a number
8 CEILING Returns the smallest integer value that is >= to a number
9 COS Returns the cosine of a number
10 COT Returns the cotangent of a number
11 COUNT Returns the number of records returned by a select query
12 DEGREES Converts a value in radians to degrees
13 DIV Used for integer division
14 EXP Returns e raised to the power of a specified number
15 FLOOR Returns the largest integer value that is <= to a number
16 GREATEST Returns the greatest value of the list of arguments
17 LEAST Returns the smallest value of the list of arguments
18 LN Returns the natural logarithm of a number
19 LOG Returns the natural logarithm of a number, or the logarithm of a number to a specified base
20 LOG10 Returns the natural logarithm of a number to base 10
21 LOG2 Returns the natural logarithm of a number to base 2
22 MAX Returns the maximum value in a set of values
23 MIN Returns the minimum value in a set of values
24 MOD Returns the remainder of a number divided by another number
25 PI Returns the value of PI

Notes