Anoop,
It's an edge list tree, so unless you can specify max recursion depth,
you need an sproc. See listing 7c at
http://www.artfulsoftware.com/mysqlbook/sampler/mysqled1ch20.html.
PB
Anoop kumar V wrote:
The resultant table should be this:
+--+---+--+
| id | nam
The resultant table should be this:
+--+---+--+
| id | name | mgr |
+--+---+--+
| 1001 | Denis Eaton-Hogg | NULL |
| 1002 | Bobbi Flekman | 1001 |
| 1003 | Ian Faith | 1002 |
| 1004 | David St. Hubbins | 1003 |
| 1005 | N
Hi Experts,
I need a small help - I think the solution is not complex, but I am not sure
where to start.
Here is my problem. I have a table that defines the employee to manager
relationship. This table will interface with another system and the users
would be created in the other system. There wi
Dear Paul,
I have a high respect and esteem for you, your book and your valuable
and effective answers to questions made by dozens of MySQL users. I am
really sorry if I have offended you with my previous e-mail. I think, we
are very busy at work, and it is better to leave for the lawyers the
sol
At 9:34 AM +0100 7/16/01, Santi Chumbe wrote:
>Interesting position. The NuSpheres people are really very clever.
If I'm reading your statement correctly, you appear to be using "clever"
as an innuendo for "mendacious." If that is so, I must respectfully
disagree, and point out that statements o
I've followed the NuSphere vs MySQL AB conflict/debate with great interest
and I really hope that the conflict will be resolved to the satisfaction
of both parties and most of all MySQL users. I was excited when NuSphere
(Progress) joined the MySQL community. Progress knows a lot about
database
Interesting position. The NuSpheres people are really very clever.
Interesante posicion. Sabiendo el respeto que tenemos por Paul, este mensaje juega a
favor de NuSphere.
Paul DuBois wrote:
> In the interests of stemming some of the flood of invective being
> directed against NuSphere...
>
>
Paul DuBois wrote:
>
> In the interests of stemming some of the flood of invective being
> directed against NuSphere...
[== snip, snip ==]
Paul:
I have a certain sympathy for your personal discomfort. I
feel that you/NuSphere are the "victims" of a kind of natural
aspect of the human condition
In the interests of stemming some of the flood of invective being
directed against NuSphere...
I am an employee of NuSphere.
Those of you who feel it necessary immediately to jump up and denounce
NuSphere for their sins, please ask yourself: Do you think I'd work for
them if I thought they wer
