MySQL Forums
Forum List  »  Newbie

Advanced Search
New Topic

Re: MySQL copy fields based on conditions
Posted by: Peter Brawley
Date: June 17, 2015 03:11PM

Is this what you mean?

update table1 a
join table2 b on a.content_id=b.post_id and a.prop_name=b.meta_key
set b.meta_value=a.content;

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Written By
Posted
MySQL copy fields based on conditions
R. G.
June 17, 2015 12:22PM
Re: MySQL copy fields based on conditions
Peter Brawley
June 17, 2015 03:11PM
Re: MySQL copy fields based on conditions
R. G.
June 18, 2015 12:55AM
Re: MySQL copy fields based on conditions
Peter Brawley
June 18, 2015 07:41AM
Re: MySQL copy fields based on conditions
R. G.
June 18, 2015 08:07AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.