RE: Foreign Keys and InnoDb in MySQL

Hello, In Case 1, you need to change: index i_Tb (customerId, carId) = index i_Tb (carId, customerId) or add index i_carId (carId) In Case 2, you need : foreign key (customerId) references customerTb (customerId) = foreign key (customerId) references customerTb (customerId) on

re: Foreign Keys and InnoDb in MySQL

Bruce, Friday, November 15, 2002, 5:35:21 AM, you wrote: BL I have a problem about foreign key in using MySQL.com manual. According to BL the example in MySQL.com manual, one foreign key is ok. However, I have 3 BL tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more BL