Mysql numeric processing functions floor and round

In mysql, when processing a number, a number processing function is used. For example, if there is a float Number of 2.13 and you want to use an integer of 2, the following function floor and round are required. 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 mysqlselec as follows

In mysql, when processing a number, a number processing function is used. For example, if there is a float Number of 2.13 and you want to use an integer of 2, the following function floor and round are required. 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 selec as follows

In mysql, when processing a value, a numeric processing function is used. For example, if there is a float value of 2.13 and you want to use an integer of 2, the following function floor and round are required.

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 & gt; select floor (5.1 );
+ ------------ +
| Floor (10, 5.1) |
+ ------------ +
| 5 |
+ ------------ +
1 row in set (0.00 sec)

Mysql & gt; select floor (5.5 );
+ ------------ +
| Floor (10, 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)