*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
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