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 key on table items
between multiple tables, or do i need to essentially create my logic/code to
handle/ensure the relationships myself. im my above exmaple, i'd rather not
have to have "foo1_id" in table foo2 as it is a duplicate of "foo1.id"....
i'd really like to be able to do something like
"unique key (id, name, foo1.id)"<<<<<
any thoughts/comments/criticisms...
thanks
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
