今天碰到一个mysql的错误,这里与大家分享一下,在mysql中执行以下语句:
update monitor set Endtime = "10:01:13"
where Id =
(select max(Id) from monitor where Portaljid = "portal" and Pathid = "path_A" )
这是会产生一个错误:
ERROR 1093 (HY000): You can't specify target table 'A' for update in FROM clause