Question

MySQL中运行更新语句update work set status='1' where ID=(select max(ID) from work)会报错

You can't specify target table 'work' for update in FROM clause
上网查了一下，需要将等号右边加别名，求助各位大神。

Answer 1

update work set status='1' where ID=(select max(ID) as ID from work)
试一下

追问

还是报错