批量修改内容

多表关联修改内容批量

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