Thank you Bruce and Paul,
Your explanation help clear a lot of doubts.
So If i create another two tables, let say INVOICE2
and LINEITEM2 with the same construct, when i specify
the index for the foreign key and referenced key,
MYSQL will create a separate index for these two
tables even i only use
At 11:40 -0700 6/7/03, Titu Kim wrote:
Hi,
I have search the mailing list about the
explanation for foreign key in Innodb. I also search
goole groups. I have the following doubts.
1. From the documentation i read about the following.
===
Both tables
Titu Kim wrote:
1. From the documentation i read about the following.
===
Both tables have to be InnoDB type and there must be
an index where the foreign key and the referenced key
are listed as the FIRST columns.
===
Hi,
I have search the mailing list about the
explanation for foreign key in Innodb. I also search
goole groups. I have the following doubts.
1. From the documentation i read about the following.
===
Both tables have to be InnoDB type and there mus
