You can't specify target table 'tb1' for update in FROM clause
批量更新数据报错, 包括额外套一层也会报错, 网上找了圈没有找到答案
update tb1
,(select id from tb1 where id in (123)) daa
set tb1.value=1
where tb1.id=daa.id按我下面的写法即可解决
update tb1
,(select id from tb1 where id in (123) limit 9999999) daa
set tb1.value=1
where tb1.id=daa.id