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

[映月2013]

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

[致命的西瓜]

update `work` set status='1' where ID=(select max(ID) from `work`)

[zjcxc]

update work a, (select max(ID) as ID from work) b set a.status='1' where a.ID=b.id

[LongRui888]

update work as w inner join (select max(ID) id from work)b on w.id = b.id set status='1'