MySQL Forums
Forum List  »  Optimizer & Parser

Re: Table reordering of multi-table DELETE
Posted by: Rick James
Date: May 27, 2009 01:21AM

Won't that delete the entire table?

Is it a bug? Perhaps not, since every row will delete itself and its parent before moving on to find other children of that parent.

Perhaps you need to discover all the descendants of some root node, then JOIN with it to delete the desired nodes.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Table reordering of multi-table DELETE
2624
May 27, 2009 01:21AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.