更新语句中不存在需要更多时间

In MySQL,

在MySQL中,

update table1 t1 
   set column1 = 100,
       column2 = 200
 where column3 > 500 
   and not exists(select * 
                    from table2 
                   where column1 = t1.column1);
update table1 t1 
   set