MySQL Forums
Forum List  »  Newbie

Re: Update table with join
Posted by: Andy Deans
Date: February 14, 2014 06:43AM

thanks, travelling at moment but will post results later.

Basically it looks like it needs to be in a loop as the update join returns more than 1 set of results.

so the results are multiple product id's which need to insert into multiple rows in folders table. cannot see on net anyway of getting it to loop other than maybe php script?

thanks

Options: ReplyQuote


Subject
Written By
Posted
February 12, 2014 06:58AM
February 13, 2014 11:13PM
February 13, 2014 11:39PM
Re: Update table with join
February 14, 2014 06:43AM
February 14, 2014 10:31AM


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.