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(...
posted @ 2014-12-25 11:39  xachary  阅读(1586)  评论(0)  编辑  收藏  举报