just some thoughts, this is a nice way of creating one "tree"-table of unlimited
levels, top-level-items has for example parent_id -1, and if you want to get the items
(the childs of a parent) just say
select * from items where parent_id = x
create table items (
item_id int unsigned not
01 1:52 PM
Subject: Re: Avoiding roundtrips
> Tomas Eriksson writes:
> > Hi.
> >
> > I guess we all are waiting for subselects in Mysql...but can you do many
> > sql-commands in a single execution, with a nice finally-result-select at
> > the end? Many round
Hi.
I guess we all are waiting for subselects in Mysql...but can you do many
sql-commands in a single execution, with a nice finally-result-select at
the end? Many roundtrips feels bad...
kind regards
Tomas
