Tag: MySQL Numeric Functions

SQL – MySQL ABS() Function

The MySQL ABS() function returns the absolute value of a number.

SQL – MySQL ACOS() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL ACOS() function returns the arc cosine of a number. The specified number must be between -1 and 1, or NULL will be returned.

SQL – MySQL ASIN() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL ASIN() function returns the arc sine of a number. The specified number must be between -1 and 1, or NULL will be returned.

SQL – MySQL ATAN() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL ATAN() function returns the arc tangent of one or two numbers.

SQL – MySQL ATAN2() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL ATAN2() function returns the arc tangent of two numbers.

SQL – MySQL AVG() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL AVG() function returns the average value of an expression (NULL values are ignored).

SQL – MySQL CEIL() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL CEIL() function returns the smallest integer value that is bigger than or equal to a number.

SQL – MySQL CEILING() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL CEILING() function returns the smallest integer value that is bigger than or equal to a number.

SQL – MySQL COS() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL COS() function returns the cosine of a number.

SQL – MySQL COT() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL COT() function returns the cotangent of a number.

SQL – MySQL COUNT() Function

August 11, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL COUNT() function returns the number of records returned by a select query. NULL values are not counted.

SQL – MySQL DEGREES() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL DEGREES() function converts a value in radians to degrees.

SQL – MySQL DIV Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL DIV function is used for integer division (x is divided by y).

SQL – MySQL EXP() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.

SQL – MySQL FLOOR() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL FLOOR() function returns the largest integer value that is smaller than or equal to a number.

SQL – MySQL GREATEST() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL GREATEST() function returns the greatest value of the list of arguments.

SQL – MySQL LEAST() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / MySQL, MySQL Numeric Functions

The MySQL LEAST() function returns the smallest value of the list of arguments.

SQL – MySQL LN() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL LN() function returns the natural logarithm of a number (greater than 0).

SQL – MySQL LOG() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.

SQL – MySQL LOG2() Function

August 13, 2024 / MySQL Functions, Reference, SQL Reference / Math, MySQL, MySQL Numeric Functions

The MySQL LOG2() function returns the natural logarithm of a number greater than 0 to base 2.