Is it me or do these dual athlons seem rather responsive!
I use mySQL 4.0.13 running on FreeBSD 4.8.
Pentium 4 2.8Ghz
2GB DDR400
1 row in set (0.7 sec) | (0.68 sec) | (0.68 sec)
Andrew.
- Original Message -
From: "Christopher Knight" <[EMAIL PROTECTED]>
To: "Mysql" <[EMAIL PROTECTED]>
Hi,
Given a simple tree structure represented in a table shown below:
group_id: int
parent_group_id: int
description: varchar
I am trying to select all rows from a table where the group_id does not
appear elsewhere as a parent_group_id, hence selecting only the leaf nodes.
I have wrestled with t