mysql round用法
时间: 2024-01-21 08:04:44 浏览: 18
在MySQL中,round函数用于对数据进行四舍五入。它有两种形式:round(x,d),其中x是要处理的数,d是要保留的小数位数。
以下是几个实例:
(1) 查询: select round(1123.26723,2); 结果:1123.27
(2) 查询: select round(1123.26723,1); 结果: 1123.3
(3) 查询: select round(1123.26723,0); 结果:1123
(4) 查询: select round(1123.26723,-1); 结果: 1120
(5) 查询: select round(1123.26723,-2); 结果:1100
(6) 查询: select round(1123.26723); 结果:1123。
此外,round(x)函数也可以用于返回参数x的四舍五入整数部分。例如,
-7 SELECT ROUND(-6.6); 结果:-7
-8 SELECT ROUND(-8.49); 结果:-8
-9 SELECT ROUND(-8.50); 结果:-9
1 SELECT ROUND(1); 结果:1
2 SELECT ROUND(1.58); 结果:2
3 SELECT ROUND(3.49); 结果:3
4 SELECT ROUND(3.50); 结果:4
而ROUND(X)与ROUND(X,0)得到的结果是相同的。例如,
1123 SELECT ROUND(1123.26723); 结果:1123
1123 SELECT ROUND(1123.26723,0); 结果:1123。
综上所述,round函数在MySQL中可以用于对数据进行四舍五入,并可以指定保留的小数位数或返回整数部分。<span class="em">1</span><span class="em">2</span><span class="em">3</span>
#### 引用[.reference_title]
- *1* *2* [mysql中的round函数(*)](https://blog.csdn.net/weixin_42408447/article/details/117996257)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
- *3* [[Mysql] ROUND函数](https://blog.csdn.net/Hudas/article/details/123699554)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v93^chatsearchT3_2"}}] [.reference_item style="max-width: 50%"]
[ .reference_list ]