Mysql rounded up the entire function ceil ()/ceiling ()

The mysqlceil (x) ceiling (x) function is used to obtain the smallest integer greater than x, that is, the rounded up Integer. This article introduces coders to mysql to obtain the entire function ceil () ceiling () for more information, see. Ceil ()/ceiling () instance:

Mysql> select ceiling (3.46); + limit + | CEILING (3.46) | + ----------------------------------------------------- + | 4 | + limit + 1 row in set (0.00 sec) mysql> select ceil (-6.43); + ------------------------------------------------------- + | CEIL (-6.43) | + limit + |-6 | + limit + 1 row in set (0.00 sec)

Note: This function is rounded up and returns the smallest integer value greater than x. Pay attention to the negative value.