我有两个表:sanctionwiththeseattributes:DriverID,Calification,Pointspeoplewiththeseattributes:pID,city,TotalPoints我有这个触发器:DROPTRIGGERIFEXISTSupdatePoints_tgr;delimiter$$CREATETRIGGERupdatePoints_tgrAFTERUPDATEONsanctionsFOREACHROWBEGINifNEW.points>OLD.pointsTHENUPDATEpeopleSETTotalPoints=TotalPoints+(

好吧，我在互联网上找了很多地方来寻找mysqlerror#1442的原因，它说Can'tupdatetable'unlucky_table'instoredfunction/triggerbecauseitisalreadyusedbystatementwhichinvokedthisstoredfunction/trigger有人说这是mysql中的错误或它不提供的功能。MySQLtriggerscan'tmanipulatethetabletheyareassignedto.AllothermajorDBMSsupportthisfeaturesohopefullyMySQLwil

我有以下触发器:CREATETRIGGERsumAFTERINSERTONnewsFOREACHROWUPDATEnewsSETNEW.sum=(NEW.int_views+NEW.ext_views)/NEW.pageviews它将表格的int_views和ext_views列相加，然后除以总浏览量。每当我尝试向新闻添加新行时，我都会收到以下错误:ERROR1442(HY000)atline3:Can'tupdatetable'news'instoredfunction/triggerbecauseitisalreadyusedbystatementwhichinvokedthiss