mathematical functions

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.

MySQL COS() Function – Return the Cosine of a Number in MySQL

November 19, 2019October 2, 2018 by Ian

In MySQL, the COS() function returns the cosine of a given value, where the value is given in radians.

The cosine is the trigonometric function that is equal to the ratio of the side adjacent to an acute angle (in a right-angled triangle) to the hypotenuse.

MySQL ABS() Function – Return the Absolute Value of a Number

November 19, 2019October 2, 2018 by Ian

In MySQL, the ABS() function returns the absolute value of a given value.

An absolute value is the distance of a number on the number line from 0 without considering which direction from zero the number lies. Therefore, the absolute value of a number is always a non-negative value (i.e. it’s never negative).