Mysql numeric processing functions floor and round_MySQL

Mysql numeric processing functions floor and round bitsCN.com
The mysql numeric processing functions floor and round are in mysql. when processing a numeric value, a numeric processing function is used. for example, if there is a float value of 2.13, you only need an integer of 2, the following functions are required: floor and round. Floor: the function returns only the integer part, and the fractional part is discarded. Round: returns the rounded value of a function. if the number is greater than 0.5, it is discarded. Different from floor. Test mysql> select floor (5.1); + ------------ + | floor (5.1) | + ------------ + | 5 | + ------------ + 1 row in set (0.00 sec) mysql> select floor (5.5); + ------------ + | floor (5.5) | + ------------ + | 5 | + ------------ + 1 row in set (0.00 sec) mysql> select round (5.2); + ------------ + | round (5.2) | + ------------ + | 5 | + ------------ + 1 row in set (0.00 sec) mysql> select round (5.5); + ------------ + | round (5.5) | + ------------ + | 6 | + ------------ + 1 row in set (0.00 sec)
BitsCN.com