多表关联修改内容批量
UPDATE table1
AS aj
INNER JOIN table2
AS a ON aj.table1id
= a.id
INNER JOIN table3
AS mp ON a.table2d
= mp.id
INNER JOIN table4
AS mlc ON mp.table3id
= mlc.id
INNER JOIN table5
AS mlcp ON mlc.table4id
= mlcp.id
INNER JOIN table6
AS ac ON ac.type_id
= COALESCE(mlcp.id
,mlc.id
) AND aj.user_id
= ac.user_id
SET aj.table6_id
= ac.id
WHERE ac.is_deleted = 1