MySQL Trigger With select

Question

Ok i have a table called motors. When something is inserted in to that table i want a trigger to run that pulls back the last row added to the table, get the fields id, description, partnum and then insert those fields in to a different table called latest.

how would i write this?

thanks

Have you tried to create something yourself or you expect something you'll copypaste and forget forever? — Michael J.V.
– Michael J.V., Commented Jul 12, 2011 at 15:46

Sam Dufel · Accepted Answer · 2011-07-12 15:46:22Z

2

CREATE TRIGGER my_trigger AFTER INSERT ON motors
FOR EACH ROW
INSERT INTO latest (motor_id, motor_description, motor_partnum) 
  VALUES (NEW.id, NEW.description, NEW.partnum);

Although, I feel obligated to tell you that if you're just trying to generate a list of the most recent motors, it'll be easier to maintain if you just select the X newest motors from the motors table.

answered Jul 12, 2011 at 15:46

Sam Dufel

17.6k3 gold badges51 silver badges52 bronze badges

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

3 Comments

SeeleyBoothe Over a year ago

So if i read you right, NEW.id, NEW.description, NEW.partnum are the fields from the motor table after it is inserted?

SeeleyBoothe Over a year ago

The reason I ask is that the id field is an auto number and is not passed when the the table is inserted to.

Sam Dufel Over a year ago

Yes, just change the .id, .description, etc to match your actual field names

Collectives™ on Stack Overflow

MySQL Trigger With select

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related