MYSQL trigger to select from and update the same table gives error #1241 - Operand should contain 1 column(s)
Posted
by
Bipin
on Stack Overflow
See other posts from Stack Overflow
or by Bipin
Published on 2012-06-03T04:29:26Z
Indexed on
2012/06/03
4:41 UTC
Read the original article
Hit count: 190
when i try to select and update the same table mysql gives error
error
#1241 - Operand should contain 1 column(s)
The trigger is
DELIMITER $$
CREATE TRIGGER visitor_validation
BEFORE INSERT ON ratingsvisitors
FOR EACH ROW
BEGIN
SET @ifexists = (SELECT * FROM ratingcounttracks WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike);
IF (@ifexists = NULL) THEN
INSERT INTO ratingcounttracks(userid, likedate, clickcount,countfor) values (New.vistorid, New.likevalidation ,'1',New.likeordislike);
ELSE
UPDATE ratingcounttracks SET clickcount=clickcount+1 WHERE userid=New.vistorid AND likedate=New.likevalidation AND countfor=New.likeordislike;
END IF;
END$$
© Stack Overflow or respective owner
