UPDATE bx_well_device_group_device dgd
LEFT JOIN ( SELECT enterprise_id, device_group_id,device_id FROM bx_well_device_group WHERE del_flag = '0' ) dg ON dg.device_group_id = dgd.device_group_id
SET dgd.del_flag = '1'
WHERE
dgd.device_id IN ( '1413326122770513921' )
AND dgd.enterprise_id IN ( '1412600293963206658' )
AND dgd.del_flag = '0';
mysql update select left join
最新推荐文章于 2023-03-17 16:57:33 发布