mysql update query ?

[ClearChaos]

im redoing the tables structures on the back of my site and ive hit a bit of a brick wall, im trying to merge the contents of two tables but i not sure on the syntax

i was thinking i could try something like...

UPDATE productsizes SET productsizes.SizeID = (SELECT sizes.productsize FROM sizes WHERE sizes.SizeID = productsizes.SizeID)

does that make sense ?

 

[Beansprout]

What're you trying to do?

 

[ClearChaos]

muppet

just tried to update an integer with a string and ended up with nothing but null values, just as well i did a backup before hand

rtfm springs to mind, anyway problem solved

 

[Beansprout]