MySQL Lists: mysql: Foreign keys and being FIRST index

List:	General Discussion	« Previous Message Next Message »
From:	Daevid Vincent	Date:	March 6 2003 2:36am
Subject:	Foreign keys and being FIRST index
View as plain text

http://www.mysql.com/doc/en/SEC457.html states that "there must be an index
where the foreign key and the referenced key are listed as the FIRST
columns." Will this restriction be lifted soon? It is incredibly
frustrating. I don't see why they have to be indexes, and more importantly,
I don't see why they have to be FIRST! Ugh.

Thread
• Foreign keys and being FIRST index	Daevid Vincent	6 Mar
• Re: Foreign keys and being FIRST index	Dan Nelson	6 Mar
• RE: Foreign keys and being FIRST index	Daevid Vincent	6 Mar
• Re: Foreign keys and being FIRST index	Dan Nelson	6 Mar
• RE: Foreign keys and being FIRST index	Keith C. Ivey	6 Mar
• Multiple foreign keys?	Daevid Vincent	8 Mar
• re: Multiple foreign keys?	Egor Egorov	8 Mar
• Re: Foreign keys and being FIRST index	William R. Mussatto	6 Mar