scvinodkumar Posted April 2, 2009 Share Posted April 2, 2009 hi i have category and subcategory in the same table previously i have not written the code to delete the subcategory while deleting the parent category. so what happens now, all the subcategory stayed in the table even their parent is deleted. now i want to delete those records only, how to do this through query? please help me Quote Link to comment https://forums.phpfreaks.com/topic/152162-delete-the-orphan-record/ Share on other sites More sharing options...
lonewolf217 Posted April 2, 2009 Share Posted April 2, 2009 it would help if you posted your database structure so we have a clearer picture of your issue Quote Link to comment https://forums.phpfreaks.com/topic/152162-delete-the-orphan-record/#findComment-799157 Share on other sites More sharing options...
scvinodkumar Posted April 2, 2009 Author Share Posted April 2, 2009 yeah sure this is the structure, here id is the category id and topicId is the parent id CREATE TABLE IF NOT EXISTS `category` ( `id` int(20) NOT NULL auto_increment, `title` varchar(255) NOT NULL, `content` text, `topicId` int(20) NOT NULL default '0', `status` varchar(50) NOT NULL default 'topic', `position` varchar(4) NOT NULL default '0', PRIMARY KEY (`id`), UNIQUE KEY `id` (`id`) ) Quote Link to comment https://forums.phpfreaks.com/topic/152162-delete-the-orphan-record/#findComment-799213 Share on other sites More sharing options...
sasa Posted April 2, 2009 Share Posted April 2, 2009 DELETE FROM `category` where `topicId` NOT IN (SELECT `id` FROM `category`) Quote Link to comment https://forums.phpfreaks.com/topic/152162-delete-the-orphan-record/#findComment-799236 Share on other sites More sharing options...
scvinodkumar Posted April 2, 2009 Author Share Posted April 2, 2009 wow what a simple query. thanks guru Quote Link to comment https://forums.phpfreaks.com/topic/152162-delete-the-orphan-record/#findComment-799239 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.