FW: [Fwd: Re: nesting tables]

2001-02-22 Thread Ed Carp
I'm forwarding this to the list, as someone asked me on list today about this, and I can't find their post to respond to... > >Speaking as someone new with MySQL. I can see your point Ed about this > >being a general database question, but were do you draw the line? If > >the tool you are using

Re: nesting tables

2001-02-22 Thread Ed Carp
revathi venkatraman ([EMAIL PROTECTED]) writes: > Sir, > Is there this concept of nesting tables and > varrays in mysql?. Iam creating a chemical compounds > database. > there are 20 field in this . Amongst them, I have a > author field where there are multiple authors, a

Re: nesting tables

2001-02-22 Thread Rolf Hopkins
What do you mean by "nesting tables" and "varrays"? What you have described is known as relational databases and a good idea would be to buy a good book on Relational Database Management Systems. - Original Message - From: "revathi venkatraman" <[EMAIL

nesting tables

2001-02-22 Thread revathi venkatraman
Sir, Is there this concept of nesting tables and varrays in mysql?. Iam creating a chemical compounds database. there are 20 field in this . Amongst them, I have a author field where there are multiple authors, amongst which one is common for all the records. suppose I query giving the