MySql Update Select 嵌套

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
)

 

转载于:https://www.cnblogs.com/xachary/p/4184300.html