1、UPDATE m_node_device mnd SET mnd.enterprise_id = (SELECT md.enterprise_id FROM m_device md WHERE mnd.device_id = md.id)
2、-- 更新表字段为查询结果中的某一个字段
UPDATE m_device md,
(
SELECT
mi.img_url AS aa,
mi.device_id AS bb
FROM
m_device_img mi
INNER JOIN m_device_type_attr ma ON ma.id = mi.device_type_attr_id
WHERE
ma.attr_name = '设备铭牌'
) b
SET md.nameplate_img = b.aa
WHERE
md.id = b.bb
AND md.nameplate_img = '' and md.is_deleted = 0