MySQL Forums
Forum List  »  French

requette mysql, besoin d'aide
Posted by: myriam arzul
Date: July 30, 2010 04:12AM

Bonjour,
j'ai une base de donnée

pid nid parentId
489 1612 0
489 1711 0
489 2666 1612
489 2667 1612
489 2668 1612
489 2696 1612
489 2697 1612
489 2698 1711
489 2699 1711
489 2700 1711
489 2701 1711
489 2702 1711

et je voudrais le résulat suivant:

pid nid parentId
489 1612 0
489 2666 1612
489 2667 1612
489 2668 1612
489 2696 1612
489 2697 1612
489 1711 0
489 2698 1711
489 2699 1711
489 2700 1711
489 2701 1711
489 2702 1711

Chaque parent suivit de ses enfants.
et tout cela en une seule requête.

merci

Options: ReplyQuote


Subject
Views
Written By
Posted
requette mysql, besoin d'aide
3407
July 30, 2010 04:12AM


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.