How can I use on delete cascade or on update cascade for more than one level? consider:
Table1
|
|--Table2
|
|--Table3
Table3 has a foreign key which references Table2 and Table2 has a foreign key references to Table1, I wanna delete some row from Table1, MySQL shows error cannot delete parent row (the row in table2). How can do what I want??
Aucun commentaire:
Enregistrer un commentaire