MySQL: You can't specify target table 'xxxtable' for update in FROM clause
https://stackoverflow.com/questions/4429319/you-cant-specify-target-table-for-update-in-from-clause
mysql不允许这样的事情发生:
update xxxtable
set col = (
select xxx from xxxtable
where ....
)
解决方式是写成这个样子,记...
原创
2020-03-19 17:07:56 ·
237 阅读 ·
0 评论