mysql update where in (查询表)
update table1 t set t.column1=0 WHERE t.id in (SELECT tid FROM table2 b)
优化
update table1 t ,table2 b set t.column1=0 where t.id=b.id ;
update table1 t set t.column1=0 WHERE t.id in (SELECT tid FROM table2 b)
优化
update table1 t ,table2 b set t.column1=0 where t.id=b.id ;