MySQL LN Function
Example Return the natural logarithm of 2: SELECT LN(2); Definition and Usage The LN() function returns the natural logarithm of a number. Note: See also the LOG() and EXP() functions.
Category SQL
MySQL LEAST Function
Example Return the smallest value of the list of arguments: SELECT LEAST(3, 12, 34, 8, 25); Definition and Usage The LEAST() function returns the smallest value of the list of arguments. Note: See also the GREATEST() function.
MySQL GREATEST Function
Example Return the greatest value of the list of arguments: SELECT GREATEST(3, 12, 34, 8, 25); Definition and Usage The GREATEST() function returns the greatest value of the list of arguments. Note: See also the LEAST() function.
MySQL FLOOR Function
Example Return the largest integer value that is less than or equal to 25.75: SELECT FLOOR(25.75); Definition and Usage The FLOOR() function returns the largest integer value that is smaller than or equal to a number. Note: Also look at…
MySQL EXP Function
Example Return e raised to the power of 1: SELECT EXP(1); Definition and Usage The EXP() function returns e raised to the power of the specified number. The constant e (2.718281…), is the base of natural logarithms. Tip: Also look…
MySQL DIV Function
Example Integer division (10/5): SELECT 10 DIV 5; Definition and Usage The DIV function is used for integer division (x is divided by y). An integer value is returned.
MySQL DEGREES Function
Example Convert the radian value into degrees: SELECT DEGREES(1.5); Definition and Usage The DEGREES() function converts a value in radians to degrees. Note: See also the RADIANS() and PI() functions.
MySQL COUNT Function
Example Return the number of products in the “Products” table: SELECT COUNT(ProductID) AS NumberOfProducts FROM Products; Definition and Usage The COUNT() function returns the number of records returned by a select query. Note: NULL values are not counted.
MySQL COT Function
Example Return the cotangent of a number: SELECT COT(6); Definition and Usage The COT() function returns the cotangent of a number. Syntax COT(number)