Is this possible w/o a stored procedure?
From: <nkaiser_at_my-deja.com>
Date: 2000/06/18
Message-ID: <8ihf4k$9dg$1_at_nnrp1.deja.com>#1/1
Date: 2000/06/18
Message-ID: <8ihf4k$9dg$1_at_nnrp1.deja.com>#1/1
I'm using mySQL, so stored procedures are not possible. I have a simple table:
ID int
PARENT_ID int
DESC varchar(10)
I want to have a query which will get all IDs under a certain PARENT_ID.
So, let's say we have: DESC (ID)
BOOKS (10)
(parent of)
TECH BOOKS (95)
(parent of)
JAVA BOOKS (134)
Now, I want a query that will recursively get all categories under 10
(BOOKS). Is that possible without a stored procedure?
Thanks!
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Sun Jun 18 2000 - 00:00:00 CEST