MySQL Triggers using data from the trigger query

Question

How do I use the data that was used to trigger the "trigger" in the trigger itself?

For example, lets assume we have a user (user_id) who created a new mission (mission_id) and therefore entered a new row in a table called missions.

Now I want to create a log in a table called log by using that specific user_id and mission_id.

What is that right syntax to do that?

StuartLC · Accepted Answer · 2014-04-30 06:28:37Z

1

You access the pseudo rows OLD and NEW to do this. New contains the new data (e.g. Inserts and new Update data), and Old contains the outgoing data (Deletes and old values prior to an update).

CREATE TRIGGER t_missions
  BEFORE INSERT ON Missions
  FOR EACH ROW
BEGIN
   INSERT INTO Log(user_id, mission_id) VALUES(new.user_id, new.mission_id);
END;

SqlFiddle here

answered Apr 30, 2014 at 6:28

StuartLC

108k18 gold badges225 silver badges294 bronze badges

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

1 Comment

Jacob Cohen Over a year ago

Can you please show me an example using the case I presented above?

Collectives™ on Stack Overflow

MySQL Triggers using data from the trigger query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related