convert insert to update

[felito]

hi

 

i have this code:

 

INSERT INTO single_user (location_home_id_location_home) 
SELECT id_location_home 
FROM location_home
WHERE location_home.location = 'London'

 

 

i am trying convert to an update but i didn't have success

 

any idea?

 

 

what i am trying:

 

update `database_charts`.`single_user` 
set `location_home_id_location_home` = id_location_home 
from location_home
where location_home.location = 'London'

 

[felito]

well, this solve my problem

update `database_charts`.`single_user` 
set `location_home_id_location_home` = 
(SELECT id_location_home 
FROM location_home
WHERE location_home.location = 'London')

 

if anyone know a better way, please share.

 

thanks