Posts
 
Reputation
Joined
Last Seen
0 Reputation Points
Unknown Quality Score

No one has voted on any posts yet. Votes from other community members are used to determine a member's reputation amongst their peers.

0 Endorsements
1 Contribution
Ranked #107.41K
Discussions / Questions x 1
~125 People Reached
Favorite Forums
Databases x 1
Favorite Tags
binary-tree x 1
cascade x 1
delete x 1
mysql x 1
recursion x 1
Member Avatar for Stju
ON DELETE CASCADE in the same table?
Share on Facebook Share on Twitter Share on LinkedIn

Let's use the basic example.. I have a table for tree representation with just 3 columns: ID, PARENT_ID,NAME. If I delete a record X, how can I delete all recursive records that refer as PARENT_ID of deleted record?

Databases binary-tree cascade delete mysql recursion table
Member Avatar for Rahul47
0
1
125