MariaDB [test]> update up b set id=0 where id=(select distinct(id) from up a where a.id=b.id); MariaDB [test]> update up b set id=0 where id=(se
阅读背景：
ERROR 1093 (HY000): You can't specify target table 'b' for update in FROM clause
来源：互联网
MariaDB [test]> update up b set id=0 where id=(select distinct(id) from up a where a.id=b.id); MariaDB [test]> update up b set id=0 where id=(se
分享到：
