RE: table layout structure

2004-07-08 Thread SGreen
Fax to: 07/08/2004 01:42 Subject: RE: table layout structure

RE: table layout structure

2004-07-08 Thread bruce
ityID requires that i now duplicate data within the system... which i want to keep to a minimum!!! thanks.. -bruce -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, July 08, 2004 10:13 AM To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: table

Re: table layout structure

2004-07-08 Thread SGreen
]To: <[EMAIL PROTECTED]> ink.net> cc: Fax to:

table layout structure

2004-07-08 Thread bruce
ps... i'm using mysql v12.22 d4.0.20 with berkely tables for the transaction processing. thanks... hi... i have an issue/prob and i'm trying to figure out the best approach... i have multiple tables foo1, foo2 foo1:foo2: - name - name - id - foo1_id - id

table layout structure

2004-07-08 Thread bruce
hi... i have an issue/prob and i'm trying to figure out the best approach... i have multiple tables foo1, foo2 foo1:foo2: - name - name - id - foo1_id - id - unique key (id, name, foo1_id) my question: does mysql provide a way to do a unique k