UPDATE `TB_CM_Dic` SET `ParentID` = (SELECT `ID` FROM (SELECT * FROM `TB_CM_Dic`) AS B WHERE `DicName` = ‘药品类别‘)WHERE `ID` = (    SELECT `ID`    FROM(        SELECT *        FROM `TB_CM_Dic`        WHERE `DicName` = ‘日常用品‘ AND `ParentID` =         (            SELECT `ID` D            FROM `TB_CM_Dic` D            WHERE D.`DicName` = ‘药品‘        )    ) AS C)