mysql sum求和字段为double类型精度不对-优快云博客

mysql sum求和字段为double类型精度不对 [问题点数：40分]

不显示删除回复显示所有回复显示星级回复显示得分回复只显示楼主

star19860411

本版等级：

结帖率：80%

楼主发表于： 2014-11-07 10:35:33

mysql sum求和字段为double类型精度不对如 select sum（t.aaa）from bbb t 当aaa类型为double的时候 sum求的和有时候会有很长的一串小数，这个问题怎么处理啊

<iframe id="cproIframe_u1636200_2" style="box-sizing: content-box;" src="http://pos.baidu.com/acom?adn=0&at=128&aurl=&cad=1&ccd=24&cec=UTF-8&cfv=0&ch=0&col=zh-CN&conBW=0&conOP=1&cpa=1&dai=2&dis=0&hn=0&layout_filter=tabcloud%2Cimage&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUc44OeiGDvHey1RDZ6N4wDkO7kLk2RVl-9e0VswJWikMoFh5m8y7LpA65zSSuL5k%26wd%3D%26eqid%3De8977339000173470000000456593dcf&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390923742&lu_161=2&lunum=6&n=csdnbaidu_cpr&pcs=1903x1074&pis=10000x10000&ps=1093x1021&psr=1920x1200&pss=1903x1200&qn=f264bc310bcc7398&rad=&rsi0=200&rsi1=22&rsi5=4&rss0=%23FFFFFF&rss1=%23FFFFFF&rss2=%23000000&rss3=&rss4=&rss5=&rss6=%23000000&rss7=&scale=&skin=&td_id=1636200&titFF=%E5%AE%8B%E4%BD%93&titFS=12&titTA=left&tn=baiduTlinkInlay&tpr=1448689191411&ts=1&version=2.0&wn=0&xuanting=0&dtm=BAIDU_DUP2_SETJSONADSLOT&dc=2&di=u1636200&ti=mysql%20sum%E6%B1%82%E5%92%8C%20%E5%AD%97%E6%AE%B5%E4%B8%BAdouble%E7%B1%BB%E5%9E%8B%20%E7%B2%BE%E5%BA%A6%E4%B8%8D%E5%AF%B9-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&tt=1448689191401.110.189.189" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" align="center,center" width="200" height="22"></iframe>
<iframe id="cproIframe_u1636201_3" style="box-sizing: content-box;" src="http://pos.baidu.com/acom?adn=0&at=128&aurl=&cad=1&ccd=24&cec=UTF-8&cfv=0&ch=0&col=zh-CN&conBW=0&conOP=1&cpa=1&dai=3&dis=0&hn=0&layout_filter=tabcloud%2Cimage&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUc44OeiGDvHey1RDZ6N4wDkO7kLk2RVl-9e0VswJWikMoFh5m8y7LpA65zSSuL5k%26wd%3D%26eqid%3De8977339000173470000000456593dcf&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390923742&lu_161=2&lunum=6&n=csdnbaidu_cpr&pcs=1903x1074&pis=10000x10000&ps=1205x1143&psr=1920x1200&pss=1903x1242&qn=ccefbbdcfd750fe3&rad=&rsi0=200&rsi1=22&rsi5=4&rss0=%23FFFFFF&rss1=%23FFFFFF&rss2=%23000000&rss3=&rss4=&rss5=&rss6=%23000000&rss7=&scale=&skin=&td_id=1636201&titFF=%E5%AE%8B%E4%BD%93&titFS=12&titTA=left&tn=baiduTlinkInlay&tpr=1448689191411&ts=1&version=2.0&wn=0&xuanting=0&dtm=BAIDU_DUP2_SETJSONADSLOT&dc=2&di=u1636201&ti=mysql%20sum%E6%B1%82%E5%92%8C%20%E5%AD%97%E6%AE%B5%E4%B8%BAdouble%E7%B1%BB%E5%9E%8B%20%E7%B2%BE%E5%BA%A6%E4%B8%8D%E5%AF%B9-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&tt=1448689191401.285.325.325" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" align="center,center" width="200" height="22"></iframe>
<iframe id="cproIframe_u1636204_4" style="box-sizing: content-box;" src="http://pos.baidu.com/acom?adn=0&at=128&aurl=&cad=1&ccd=24&cec=UTF-8&cfv=0&ch=0&col=zh-CN&conBW=0&conOP=1&cpa=1&dai=4&dis=0&hn=0&layout_filter=tabcloud%2Cimage&ltr=https%3A%2F%2Fwww.baidu.com%2Flink%3Furl%3DUc44OeiGDvHey1RDZ6N4wDkO7kLk2RVl-9e0VswJWikMoFh5m8y7LpA65zSSuL5k%26wd%3D%26eqid%3De8977339000173470000000456593dcf&ltu=http%3A%2F%2Fbbs.youkuaiyun.com%2Ftopics%2F390923742&lu_161=2&lunum=6&n=csdnbaidu_cpr&pcs=1903x1074&pis=10000x10000&ps=1205x1265&psr=1920x1200&pss=1903x1242&qn=11351b0a506796c4&rad=&rsi0=200&rsi1=22&rsi5=4&rss0=%23FFFFFF&rss1=%23FFFFFF&rss2=%23000000&rss3=&rss4=&rss5=&rss6=%23000000&rss7=&scale=&skin=&td_id=1636204&titFF=%E5%AE%8B%E4%BD%93&titFS=12&titTA=left&tn=baiduTlinkInlay&tpr=1448689191411&ts=1&version=2.0&wn=0&xuanting=0&dtm=BAIDU_DUP2_SETJSONADSLOT&dc=2&di=u1636204&ti=mysql%20sum%E6%B1%82%E5%92%8C%20%E5%AD%97%E6%AE%B5%E4%B8%BAdouble%E7%B1%BB%E5%9E%8B%20%E7%B2%BE%E5%BA%A6%E4%B8%8D%E5%AF%B9-优快云%E8%AE%BA%E5%9D%9B-youkuaiyun.com-%E4%B8%AD%E5%9B%BD%E6%9C%80%E5%A4%A7%E7%9A%84IT%E6%8A%80%E6%9C%AF%E7%A4%BE%E5%8C%BA&tt=1448689191401.419.442.442" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" align="center,center" width="200" height="22"></iframe>

对我有用[0] 丢个板砖[0] 引用 | 举报 | 管理

回复次数：4

zlloct CT_LXL 本版等级：	#1 得分：0 回复于： 2014-11-07 13:42:45 引用楼主 star19860411 的回复:用round函数可以指定保留几位：如下 round(123.456,2) --> 123.46
	随时随地逛论坛论坛移动客户端对我有用[0] 丢个板砖[0] 引用 \| 举报 \| 管理

rucypli rucypli 本版等级：	#2 得分：0 回复于： 2014-11-07 17:58:25 做sum能多出很多小数？
	对我有用[0] 丢个板砖[0] 引用 \| 举报 \| 管理

u013240005 SQL-木子Lee 本版等级：	#3 得分：0 回复于： 2014-11-08 23:03:08 1，用round四舍五入 round（999.53,1）结果 999.5 2，用TRUNCATE截断 TRUNCATE(1.223,1); 结果 1.2
	对我有用[0] 丢个板砖[0] 引用 \| 举报 \| 管理