Re: UPDATE statement...can't use FROM?

[Peter Brawley]

As the manual page for Update says (https://dev.mysql.com/doc/refman/8.0/en/update.html), "You cannot update a table and select directly from the same table in a subquery. You can work around this by using a multi-table update ..."

... Or a CTE eg given table t(id,d,val) ...

with cte as ( 
  select id from t where year(d)=2021 
)
update t 
join cte using(id) 
set t.val=t.val*1.05;