functions – Page 124

MySQL LN() Function – Return the Natural Logarithm of a Number

November 19, 2019October 12, 2018 by Ian

In MySQL, the LN() function returns the natural logarithm of a specified value.

You provide the specified value as an argument when calling the function.

This function is synonymous with the single-argument syntax of the LOG() function.

MySQL EXP() Function – Return e Raised to the Power of x

November 19, 2019October 10, 2018 by Ian

In MySQL, the EXP() function returns e raised to the power of a specified value.

You provide the specified value as an argument when calling the function.

The number e is a mathematical constant that is the base of the natural logarithm: the unique number whose natural logarithm is equal to one. It is approximately equal to 2.71828.

MySQL ATAN2() Function – Return the Arc Tangent of 2 Values

November 19, 2019October 9, 2018 by Ian

In MySQL, the ATAN2() function returns the arc tangent of two values.

You provide the two values as comma-separated arguments when calling the function.

MySQL ATAN() Function – Return the Arc Tangent of a Value (or Values)

November 19, 2019October 8, 2018 by Ian

In MySQL, the ATAN() function returns the arc tangent of a value. It can also be used to return the arc tangent of two values.

You provide the value/s as an argument when calling the function.

MySQL ASIN() Function – Return the Arc Sine of a Number

November 19, 2019October 8, 2018 by Ian

In MySQL, the ASIN() function returns the arc sine of a number.

You provide the number as an argument when calling the function.

MySQL ACOS() Function – Return the Arc Cosine of a Number

November 19, 2019October 8, 2018 by Ian

In MySQL, the ACOS() function returns the arc cosine of a number.

You provide the number as an argument when calling the function.

MySQL RADIANS() Function – Convert From Degrees to Radians

November 19, 2019October 7, 2018 by Ian

In MySQL, the RADIANS() function converts a value from degrees to radians, and returns the result.

You provide the value in degrees as an argument when calling the function.

MySQL DEGREES() Function – Convert From Radians to Degrees

November 19, 2019October 5, 2018 by Ian

In MySQL, the DEGREES() function converts a value from radians to degrees, and returns the result.

You provide the radian value as an argument when calling the function.

MySQL CRC32() Function – Examples

November 19, 2019October 4, 2018 by Ian

In MySQL, the CRC32() function computes a cyclic redundancy check value and returns a 32-bit unsigned value.

CRC stands for Cyclic Redundancy Check. A CRC is an error-detecting code commonly used in digital networks and storage devices to detect accidental changes to raw data (although, it doesn’t necessarily guard against malicious or intentional changes).

MySQL COT() Function – Return the Cotangent of a Number in MySQL

November 19, 2019October 4, 2018 by Ian

In MySQL, the COT() function returns the cotangent of a given value.

You provide the value as an argument when calling the function.