On Thu, Jan 20, 2011 at 17:00, Richard Quadling <rquadl...@gmail.com> wrote: > I'd have my items table, my tags table and a join table for the two. > My join table is really simple. UniqueID, ItemID, TagID. >
Yes, that is the first approach that I mentioned. It looks to be a good compromise. > I'd recommend using a nested set approach for the tags > (http://dev.mysql.com/tech-resources/articles/hierarchical-data.html > gives a good explanation on the issues and methodology of nested > sets). > That is terrific, at least the first half. The second half, with the Venn diagrams, is awkward! -- 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=arch...@jab.org
