删除子孙
下面可以创建一个表并插入数据:
CREATE TABLE IF NOT EXISTS `schools` (
`id` int(11) NOT NULL,
`pid` int(11) NOT NULL,
`bt` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
INSERT INTO `schools` (`id`, `pid`, `bt`) VALUES
(1, 0, '学校'),
(2, 1, '信息系'),
(3, 2, '软件教研室'),
(4, 3, '张三'),
(5, 2, '硬件教研室'),
(6, 5, '李四'),
(7, 1, '水利系'),
(8, 7, '水工教研室'),
(9, 8, '王五');
请问如何删除子孙?比如要删除id号=2时,则同时删除3,4,5,6号记录?O(∩_∩)O谢谢啦~~~