Page 1 of 1

cascading delete using phpmyadmin

Posted: Fri Mar 26, 2010 9:23 am
by majidali
can anyone explain me in steps how to implement cascading delete through phpmyadmin....

Re: cascading delete using phpmyadmin

Posted: Fri Mar 26, 2010 9:40 am
by mikosiko
Referential Integrity rules are implemented at Database level... phpmyadmin allows you to define those rules to certain extents

- Select your database
- Select your table
- look for "Relation View" option... there you can define your FOREIGN Key(s) ON DELETE, or ON UPDATE events

Re: cascading delete using phpmyadmin

Posted: Sun Mar 28, 2010 2:21 am
by DaiLaughing
You do need to be using InnoDB and not MyISAM for this to work.

The tab is called Designer in my (slightly out of date because I'm lazy) version.