DROP TABLE IF EXISTS `T_DeviceRel`;
CREATE TABLE `T_DeviceRel` (
`Id` int(11) NOT NULL auto_increment,
`pid` int(11) default NULL,
`deviceId` int(11) default NULL,
`deviceTypeId` int(11) default NULL,
PRIMARY KEY (`Id`)
)INSERT INTO `T_DeviceRel` VALUES (1,0,1,1);
INSERT INTO `T_DeviceRel` VALUES (2,0,2,1);
INSERT INTO `T_DeviceRel` VALUES (3,0,3,1);
INSERT INTO `T_DeviceRel` VALUES (4,0,4,1);
INSERT INTO `T_DeviceRel` VALUES (5,0,5,1);
INSERT INTO `T_DeviceRel` VALUES (6,1,1,2);
INSERT INTO `T_DeviceRel` VALUES (7,2,22,2);
INSERT INTO `T_DeviceRel` VALUES (8,3,23,2);
INSERT INTO `T_DeviceRel` VALUES (9,3,30,2);
INSERT INTO `T_DeviceRel` VALUES (10,3,31,2);
INSERT INTO `T_DeviceRel` VALUES (11,3,32,2);
INSERT INTO `T_DeviceRel` VALUES (12,3,36,2);
INSERT INTO `T_DeviceRel` VALUES (13,3,6,3);
INSERT INTO `T_DeviceRel` VALUES (14,6,7,3);
INSERT INTO `T_DeviceRel` VALUES (15,3,2,3);
INSERT INTO `T_DeviceRel` VALUES (16,1,3,3);
INSERT INTO `T_DeviceRel` VALUES (17,7,4,3);
INSERT INTO `T_DeviceRel` VALUES (18,1,5,3);
INSERT INTO `T_DeviceRel` VALUES (19,12,5,3);id pid deviceId deviceTypeId
1 0 1 1
2 0 2 1
3 0 3 1 7 1 22 2
8 1 23 2
9 3 30 2 13 7 6 3 15 8 2 3
16 7 3 3
17 7 4 3
pid 是父节点。我要删除 id=1这条记录时同时也要删除它的所有子节点
请各位高手指教!!!!!!!!!!!!!!!
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货