Re: [PHP-DB] MySQL Foreign Key Issue

2007-03-27 Thread OKi98
Luchino - Samel wrote: *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). I

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] MySQL Foreign Key Issue

2007-03-25 Thread Lasitha Alawatta
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 ORDERS column name characteristic Order_ID Primary Key Order_Date Customer_SID Foreign Key Amount When I run