update in 的优化写法

update table_name set column = 'xxx' where column2 in (select x from table_name2 where xxxxxx)

update table_a a join table_b b on a.xx=b.xx
set a.xx=要变更的值
where b.xx=条件值

EXPLAIN
UPDATE t_form_template_function SET del_flag = '1' WHERE struct_id IN ( SELECT DISTINCT id FROM t_form_template_struct WHERE pid = 'GE148389280359880457831') and del_flag='0' ;

EXPLAIN
UPDATE t_form_template_function f JOIN t_form_template_struct s ON f.struct_id = s.id SET f.del_flag = '1' 
WHERE s.pid = 'GE148389280359880457831' AND f.del_flag = '0';