MySQL CREATE TRIGGER, Syntax Error. What I'm doing wrong?

Question

 DELIMITER ||
CREATE TRIGGER `monthly_insert` BEFORE INSERT ON `history_monthly`
FOR EACH ROW
BEGIN
    NEW.`uid` = CONCAT(OLD.`year`, OLD.`month`, OLD.`charactersId`);
END;
||
DELIMITER ;

And it returns an error:

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.`uid` = CONCAT(OLD.`year`, OLD.`month`, OLD.`charactersId`);
END' at line 4

It's my first time with triggers and I was doing my best to try to find soultion but I failed ;<

If this is a BEFORE INSERT trigger, surely there won't be an old row? — Brian Hooper
– Brian Hooper, Commented Feb 9, 2011 at 18:37

Ike Walker · Accepted Answer · 2011-02-09 18:46:15Z

1

You need to add the word SET in this line:

SET NEW.`uid` = CONCAT(OLD.`year`, OLD.`month`, OLD.`charactersId`);

Also, as the commenter pointed out, there is no OLD value in a BEFORE INSERT trigger.

answered Feb 9, 2011 at 18:46

Ike Walker

65.8k14 gold badges115 silver badges112 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL CREATE TRIGGER, Syntax Error. What I'm doing wrong?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related