INSERT INTO forklift.t_project_dt_energy_consume(project_id,project_name,dt,today_energy) SELECT d.project_id,d.project_name,DATE(NOW()), SUM(d.today_energy) as today_energy FROM st_newstw.datav_information d WHERE DATE(d.times) = DATE(NOW()) GROUP BY d.project_id ON DUPLICATE KEY UPDATE today_energy = SUM(d.today_energy);
时间: 2023-02-13 17:46:29 浏览: 105
这是一个 MySQL 数据库的 INSERT INTO SELECT 语句,用于将数据从一个表复制到另一个表中。
在这个语句中,它会将 st_newstw 数据库中 datav_information 表中日期(times 列)为当天的记录按项目 ID(project_id 列)分组,并将每组的今日能耗(today_energy 列)求和。然后将结果插入到 forklift 数据库的 t_project_dt_energy_consume 表中。如果项目 ID 已存在于 t_project_dt_energy_consume 表中,则将今日能耗(today_energy 列)更新为求和后的值。
如果你对这个语句有其他疑问,请告诉我,我会尽力帮助你。
阅读全文
相关推荐
![-](https://img-home.csdnimg.cn/images/20210720083447.png)
![-](https://img-home.csdnimg.cn/images/20241231045053.png)
![-](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![dmg](https://img-home.csdnimg.cn/images/20250102104920.png)
![gz](https://img-home.csdnimg.cn/images/20210720083447.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![.zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![dmg](https://img-home.csdnimg.cn/images/20250102104920.png)
![dmg](https://img-home.csdnimg.cn/images/20250102104920.png)
![zip](https://img-home.csdnimg.cn/images/20241231045053.png)
![rar](https://img-home.csdnimg.cn/images/20241231044955.png)