草庐IT

ratingcounttracks

全部标签

从中选择并更新同一个表的 MYSQL 触发器给出错误 #1241 - 操作数应包含 1 列

当我尝试选择和更新同一个表时,mysql出错error#1241-Operandshouldcontain1column(s)触发器是DELIMITER$$CREATETRIGGERvisitor_validationBEFOREINSERTONratingsvisitorsFOREACHROWBEGINSET@ifexists=(SELECT*FROMratingcounttracksWHEREuserid=New.vistoridANDlikedate=New.likevalidationANDcountfor=New.likeordislike);IF(@ifexists=NUL