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. Www.2cto.com round: returns a function rounded to 0.5. If it is not found, 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) www.2cto.com 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)