Syntax error when trying to insert from a mysql trigger

Question

I'm trying to create a trigger to insert into a new table using values from two different tables (I'm using MySQL 5.5.27).

I get a syntax error when I try this but cannot see where the error is.

    DECLARE _Token VARCHAR(255);
SELECT token INTO _Token FROM appusers ON username = NEW.username;
INSERT INTO queue (token, message) VALUES (_Token, NEW.milestone);

My assumption is that it doesn't like the DECLARE because when I use the following I get message that _Token is an undeclared variable.

  SELECT token INTO _Token FROM appusers ON username = NEW.username;
INSERT INTO queue (token, message) VALUES (_Token, NEW.milestone);

peterm · Accepted Answer · 2013-05-05 04:42:50Z

2

Try do it with a single insert statement

INSERT INTO queue (token, message)
SELECT token, NEW.milestone
  FROM appusers 
 WHERE username = NEW.username;

answered May 5, 2013 at 4:42

peterm

93k16 gold badges157 silver badges162 bronze badges

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

Collectives™ on Stack Overflow

Syntax error when trying to insert from a mysql trigger

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