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 ; 阅读全文
posted @ 2021-11-09 15:27 血翼残飞 阅读(2241) 评论(0) 推荐(0) 编辑