MySQL Forums
Forum List  »  PHP

Advanced Search
New Topic

Re: Need help with SQL query
Posted by: Peter Brawley
Date: January 24, 2016 02:42PM

> parent 0 (root).

Not ideal. Better null.

Some variants of SQL have a recursion operator, MySQL doesn't, so you need procedural logic or manually coded joins, see http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html

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


Subject
Written By
Posted
Need help with SQL query
Doug Matthews
January 24, 2016 12:13PM
Re: Need help with SQL query
Peter Brawley
January 24, 2016 02:42PM
Re: Need help with SQL query
Shay _Fox
January 25, 2016 03:54PM
Re: Need help with SQL query
Peter Brawley
January 25, 2016 04:06PM
Re: Need help with SQL query
Doug Matthews
January 26, 2016 11:15PM


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.