Shulou(Shulou.com)06/01 Report--

The following mainly brings you the main mathematical functions available in MySQL. I hope these contents can bring you practical use. This is also the main purpose of this article that I edit the main available mathematical functions in MySQL. All right, don't talk too much nonsense, let's just read the following.

ABS () returns the absolute value of the given value.

ACOS () returns the inverse cosine of the number.

ASIN () returns the arcsine of a number.

ATAN () returns the arc tangent of one or more values.

ATAN2 () returns the arc tangent of two parameters.

The synonym for CEIL () is CEILING ().

CEILING () rounds a number to the nearest integer (returns the smallest integer not less than its parameter).

CONV () converts numbers between different cardinals.

COS () returns the cosine of the number.

COT () returns the cotangent of the number.

CRC32 () calculates the cyclic redundancy check value.

DEGREES () converts from radians to degrees.

EXP () returns the power of e to x.

FLOOR () rounds the number down to the nearest integer (returns the maximum integer value not greater than the parameter).

LN () returns the natural logarithm of a number.

LOG () returns the natural logarithm of a number. It also allows you to specify the cardinality.

LOG10 () returns the base 10 logarithm of the parameter.

LOG2 () returns the base 2 logarithm of the parameter.

MOD () performs modular operations. Returns the remainder of N divided by M.

PI () returns the value of π (pi).

POW () returns the thrown parameter to the specified power.

The synonym POW () for POWER ().

RADIANS () converts the value from degrees to radians and returns the result.

RAND () returns a random floating point value.

ROUND () rounds the number up or down to the given number of decimal places.

SIGN () returns the symbol of the parameter (so you can know whether the number is positive or negative).

SIN () returns the sine of the parameter.

SQRT () returns the square root of the parameter.

TAN () returns the tangent of the parameter.

TRUNCATE () truncates the value to the specified number of decimal places.

For the above about the main mathematical functions available in MySQL, we do not think it is very helpful. If you need to know more, please continue to follow our industry information. I'm sure you'll like it.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.