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)