cascading delete using phpmyadmin

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
majidali
Forum Newbie
Posts: 17
Joined: Thu Mar 11, 2010 3:33 am

cascading delete using phpmyadmin

Post by majidali »

can anyone explain me in steps how to implement cascading delete through phpmyadmin....
mikosiko
Forum Regular
Posts: 757
Joined: Wed Jan 13, 2010 7:22 pm

Re: cascading delete using phpmyadmin

Post 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
DaiLaughing
Forum Commoner
Posts: 76
Joined: Thu Jul 16, 2009 8:03 am

Re: cascading delete using phpmyadmin

Post 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.
Post Reply