Re: [PHP-DB] MySQL Foreign Key Issue

2007-03-26 Thread Luchino - Samel
*Question No. 01* there are some kind of foreign key in database Some of them want give any error when you delete from the table where the foreign key is in, this cause the remove is recursive and it delete also the ORDER linked to the CUSTOMER (CASCADE foreign key). In other kind of foreign key

[PHP-DB] Re: MySQL Foreign Key Issue

2007-03-26 Thread Roberto Mansfield
Are you using InnoDB for you tables? Lasitha Alawatta wrote: Hello, I have 2 issue, regarding MySQL “Foreign Key”. I have two tables; Table 01 */CUSTOMER/* column name characteristic SID Primary Key Full_Name Table