MySQL – Page 39

How the EXPORT_SET() Function Works in MySQL

November 19, 2019November 13, 2018 by Ian

The MySQL EXPORT_SET() function returns a string that represents the bits in a number.

You have the ability to customise how the function outputs the string. The function accepts a number of arguments that allows you to do this. When you call the function, you provide the number in question, as well as arguments that determine how the results are displayed.

MySQL Mathematical Functions (Full List)

November 19, 2019November 6, 2018 by Ian

MySQL includes a bunch of functions and operators that can help us when working with data.

The following is a list of mathematical functions available in MySQL. You can click on each function name to see an explanation of the function, its syntax, and examples.

MySQL TRUNCATE() Function – Truncate a Number to a Specified Number of Decimal Places

November 19, 2019October 22, 2018 by Ian

In MySQL, the TRUNCATE() function truncates a value to a specified number of decimal places.

The function accepts two arguments; the value, and the number of decimal places to truncate that value to.

All numbers are rounded toward zero.

MySQL TAN() Function – Return the Tangent of a Value in MySQL

November 19, 2019October 20, 2018 by Ian

In MySQL, the TAN() function returns the tangent of a value.

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

MySQL SQRT() Function – Return the Square Root of a Number in MySQL

November 19, 2019October 19, 2018 by Ian

In MySQL, the SQRT() function returns the square root of a nonnegative number.

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

MySQL SIN() Function – Return the Sine of a Number in MySQL

November 19, 2019October 19, 2018 by Ian

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

The sine is a trigonometric function of an angle. The sine of an acute angle is defined in the context of a right triangle: for the specified angle, it is the ratio of the length of the side that is opposite that angle to the length of the longest side of the triangle (the hypotenuse).

MySQL SIGN() Function – Find Out Whether a Number is Positive or Negative in MySQL

November 19, 2019October 19, 2018 by Ian

In MySQL, the SIGN() function returns the sign of a number. That is, it indicates whether or not the value is a positive number, a negative number, or zero.

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

The function returns the following result, depending on whether the argument is positive, negative, or zero.

1 if the number is positive
-1 if the number is negative
0 if the number is zero

MySQL POW() Function – Raise a Value to the Power of Another Value

November 19, 2019October 17, 2018 by Ian

In MySQL, the POW() function raises a number to the power of another number.

You provide the two values as arguments when calling the function.

MySQL MOD() Function – Perform a Modulo Operation in MySQL

November 19, 2019October 16, 2018 by Ian

In MySQL, the MOD() function performs a modulo operation. It returns the remainder of a number divided by another number.

You provide the two values as arguments when calling the function.

MySQL LOG10() Function – Return the Base-10 Logarithm of a Value

November 19, 2019October 16, 2018 by Ian

In MySQL, the LOG10() function returns the base-10 logarithm of a specified value.

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