samedi 28 février 2015

MySQL on delete cascade some levels


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