mysql函數ceil、floor、round
- mysql 取整
mysql 取整
1.ceil() / ceiling() 向上取整
ex: ceil(1.2) = 2
2.floor() 向下取整
ex: floor(1.2) = 1
3.round() 四舍五入
參考連結
[1]: https://www.cnblogs.com/myblog1900/p/10031991.html
1.ceil() / ceiling() 向上取整
ex: ceil(1.2) = 2
2.floor() 向下取整
ex: floor(1.2) = 1
3.round() 四舍五入
參考連結
[1]: https://www.cnblogs.com/myblog1900/p/10031991.html