CREATE TABLE IF NOT EXISTS `pers` ( `persID` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(35) NOT NULL, `gehalt` int(11) NOT NULL, `chefID` int(11) DEFAULT NULL, PRIMARY KEY (`persID`)) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;INSERT INTO `pers` (`persID`,`name`,`gehalt`,`chefID`) VALUES(1,'blb(二),as1000,3),chef',1040,NULL); ! X6 L$ Y* M! n& ^" G: w
我试着操作以下更新,但只收到了1093的错误: 2 I0 L# R2 y" C
UPDATE pers P SET P.gehalt = P.gehalt * 1.05 WHERE (P.chefID IS NOT NULL OR gehalt < (SELECT SELECT MAX(gehalt * 1. FROM pers MA WHERE MA.chefID = MA.chefID) AS _pers)) . K$ S% p4 F5 z# ^. ~3 Y( s/ ^