cascading delete using phpmyadmin
Moderator: General Moderators
cascading delete using phpmyadmin
can anyone explain me in steps how to implement cascading delete through phpmyadmin....
Re: cascading delete using phpmyadmin
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
- 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
-
DaiLaughing
- Forum Commoner
- Posts: 76
- Joined: Thu Jul 16, 2009 8:03 am
Re: cascading delete using phpmyadmin
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.
The tab is called Designer in my (slightly out of date because I'm lazy) version.