Re: Equivalent for all_catalog
Posted by:
Bob Field
Date: June 14, 2006 02:04PM
Some notes here on foreign key constraints:
http://dev.mysql.com/doc/refman/5.0/en/innodb-foreign-key-constraints.html
In particular note this bit:
"In the referenced table, there must be an index where the referenced columns are listed as the first columns in the same order."
So it's nothing to do with the auto_increment attribute, only that an additional index is required on the column that is to be referenced from the other table. This apparently does not have to be a UNIQUE key according to the above excerpt.
Subject
Views
Written By
Posted
5465
June 14, 2006 08:54AM
2410
June 14, 2006 09:04AM
2929
June 14, 2006 09:25AM
2321
June 14, 2006 11:13AM
2680
June 14, 2006 11:22AM
2406
June 14, 2006 11:31AM
2815
June 14, 2006 11:39AM
2596
June 14, 2006 11:52AM
Re: Equivalent for all_catalog
2507
June 14, 2006 02:04PM
2511
June 14, 2006 06:12PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.