[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql
Subject:    RE: [PHP] RE: Organisational question: surely someone has implemented many Boolean values (tags) and
From:       "Jerry Schwartz" <jerry () gii ! co ! jp>
Date:       2011-01-20 21:46:31
Message-ID: 000001cbb8eb$81b96f70$852c4e50$ () co ! jp
[Download RAW message or body]

>> [JS] I disagree. The method I proposed can be extended to any depth, and 
>> any
>> leaf or branch can be retrieved with a single query.
>>
>
>I suppose for retrievals this structure has advantages, but unless
>MySQL has a ++ operator (or better yet, one that adds or subtracts 2
>from an int) then it looks to be a pain to add nodes.
>
[JS] Not at all. Somebody, somehow, has to assign a name to the tag and 
designate its place in the hierarchy. I don't see how you can avoid that being 
done by a human.

Regards,

Jerry Schwartz
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032

860.674.8796 / FAX: 860.674.8341
E-mail: jerry@gii.co.jp
Web site: www.the-infoshop.com




>But I will play with the idea. Maybe after I write the code (I'm
>saving that for tomorrow) I'll see it differently. Thanks.
>
>--
>Dotan Cohen
>
>http://gibberish.co.il
>http://what-is-what.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=mysql-marcsub@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]