mysql删除子节点语句_mysql中递归删除父节点及所有其子节点

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&n