Re: Hierarchical lists

2001-04-09 Thread Tomas Eriksson
signed not null auto_increment parent_id int unsigned not null default -1 somedata varchar(1000) ) kinds regards Tomas - Original Message - From: "Realbad Atgames" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 1:12 AM Subject: Hiera

Re: Hierarchical lists

2001-04-08 Thread Thalis A. Kalfigopoulos
On Sun, 8 Apr 2001, Realbad Atgames wrote: > > --- [EMAIL PROTECTED] wrote: > > > > > Hello, I'm new to MySQL and have ran into a > > problem in > > > designing my database. I have a table of items, A, > > and > > > each item should have any number of other records > > from > > > another table,

Re: Hierarchical lists

2001-04-08 Thread Realbad Atgames
--- [EMAIL PROTECTED] wrote: > > > Hello, I'm new to MySQL and have ran into a > problem in > > designing my database. I have a table of items, A, > and > > each item should have any number of other records > from > > another table, B, associated with it. I also need > to > > have any number of

Hierarchical lists

2001-04-08 Thread Realbad Atgames
Hello, I'm new to MySQL and have ran into a problem in designing my database. I have a table of items, A, and each item should have any number of other records from another table, B, associated with it. I also need to have any number of records from table C associated with table B. They need to be