mysql将查询到的信息update到原始表

最新推荐文章于 2024-07-20 16:33:27 发布

live for myself

最新推荐文章于 2024-07-20 16:33:27 发布

阅读量128

点赞数 2

分类专栏： MySql 文章标签： mysql 数据库

本文链接：https://blog.csdn.net/crystal4000/article/details/137608018

版权

MySql 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

将s表的栏位outputWeight，outputQuantity更新到middle的output_Weight和output_quantity栏位

UPDATE middle
JOIN (SELECT    
				a.machine_alias as machineAlias,
        a.mo as mo,
        a.start_time,
				a.end_time,
        cast(round(b.actqty*wo.netWeigthSU,1) as float)outputWeight,
				(b.actqty) as outputQuantity,
        from(
 SELECT machine_alias, mo, input_quantity, start_time, end_time FROM middle where mo = '1014626')a 
		LEFT JOIN wo as wo on TRIM(wo.banummer)=a.mo
        LEFT JOIN
        (SELECT ywo,CAST(SUM(actqty)AS FLOAT)actqty,CAST(sum(scrapqty)AS FLOAT)scrapqty FROM pdcs as pdc WHERE workcentername like'挤压%'and yworkdate =  (SELECT DATE_FORMAT((SELECT DATE_SUB('2024-04-04 05:27:27', INTERVAL 1 DAY)), '%y/%m/%d') AS formatted_date)  GROUP BY ywo)b on b.ywo=a.mo ) as s
          ON mo_log_middle.mo = s.mo 
SET middle.output_Weight = s.outputWeight, middle.output_quantity = s.outputQuantity