I use the following query:
update city
set CountryCode = (select CountryCode from city where id = 1)
where id =4081;
and I am getting the below error:
Error Code: 1093. You can't specify target table 'city' for update in FROM clause
but I am not sure why this is not allowing me to do so?