MySQL Forums
Forum List  »  Newbie

Re: Get all Child nodes and check for duplicate or repeated
Posted by: MuraliDharan V
Date: January 19, 2017 07:35AM

Thanks for your reply,

For product id 100

100-->101,102 - has two subproducts (In Level1)
102-->no more subproducts(In Level1),
again for the products 101,
101-->103,100,104 - has two subproducts, but 100 is already in the main product and it leads to recursive repetitive loop, so i need to omit 100 and to just continue with 103,104 (In Level2)
then 104-->105 (in Level3) till there are no more sub product records found.

Thanks,
Murali.V

Options: ReplyQuote


Subject
Written By
Posted
Re: Get all Child nodes and check for duplicate or repeated
January 19, 2017 07:35AM


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.