这样的sql怎么写呀
我写的这个有错误 update account set remnant =(remnant-10) where remnant in (select remnant from account where id=2)
我写的这个有错误 update account set remnant =(remnant-10) where remnant in (select remnant from account where id=2)
You can't specify target table 'account' for update in FROM clauseExecution Time : 00:00:00:000
Transfer Time : 00:00:00:000
Total Time : 00:00:00:000
set a.remnant =(a.remnant-10)
where a.remnant=b.remnant