update column data according to a query based on existing column

[dflow]

i have a CityName Column in an old products table

 

i would like to create a CityID according to the cityname and update the CityID column

 

i have city_list table

with CityID as primary

CityName

 

products table

ProductID as Primary

CityID (Blank INT)

CityName(with cityname varchar)

 

so insense have

CityName=Amsterdam=CityID=1

how can i run an update column CityID according to city_list cityname

hope im clear

 

thanks

[luca200]

hope im clear

you could do better actually :-D

Anyway, hoping I understood, you could give it a try like this:

 

update products p join city_list c on (p.CityName = c.CityName) SET p.CityID = c.CityID

[dflow]

you got me loud and clear thanks alot