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

RE: Foreign Keys and InnoDb in MySQL

quot;foreign key (customerId) references customerTb (customerId) on delete cascade". José Ceferino Ortega -Mensaje original- De: Bruce Lee [mailto:itnobita@;hotmail.com] Enviado el: viernes, 15 de noviembre de 2002 4:35 Para: [EMAIL PROTECTED] Asunto: Foreign Keys and InnoDb in MyS

Foreign Keys and InnoDb in MySQL

Hello, I have a problem about foreign key in using MySQL.com manual. According to the example in MySQL.com manual, one foreign key is ok. However, I have 3 tables (ie. 2 for parent tables and 1 for child table). When I use 2 or more foreign keys, I have the following errors. Case 1: mysql> cr