首页 > 数据库技术 > 详细

MySQL--指定浮点型数据的精确度TRUNCATE

时间:2017-02-06 15:57:51      阅读:331      评论:0      收藏:0      [点我收藏+]
INSERT INTO perf_week(node_id,perf_time,pm25,pm10,temp,humi)
SELECT node_id,2016-12-08 11:55:00 AS perf_time,TRUNCATE(AVG(pm25),2) AS pm25,TRUNCATE(AVG(pm10),2) AS pm10,
TRUNCATE(AVG(curr_temp),2) AS temp,TRUNCATE(AVG(curr_humidity),2) AS humi FROM perf_pm25 WHERE perf_time BETWEEN DATE_SUB(2016-12-08 11:55:00,INTERVAL 1 WEEK) AND 2016-12-08 11:55:00 GROUP BY node_id;

啦啦啦

MySQL--指定浮点型数据的精确度TRUNCATE

原文:http://www.cnblogs.com/ClassNotFoundException/p/6370539.html

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!