MySQL Trigger Not Functioning

Question

I have created this Trigger. However, when inserting into dbase, nothing happens?

DELIMITER $$

USE `collectionsmax`$$

CREATE
    TRIGGER `DupeCheck` AFTER INSERT ON `dbase` 
    FOR EACH ROW BEGIN
        update dbase set reportfilenumber=socialsecruitynumber where id = new.id;
    END;
$$

DELIMITER ;

Community · Accepted Answer · 2017-05-23 12:27:17Z

1

You can't execute DML statements against the table your trigger is written against. This is a caveat in most databases.

See MySQL - Trigger for updating same table after insert. The accepted answer has a different way of approaching the same problem.

edited May 23, 2017 at 12:27

CommunityBot

11 silver badge

answered Jan 15, 2015 at 16:23

Tripp Kinetics

5,4892 gold badges25 silver badges40 bronze badges

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

1 Comment

Adam Reed Over a year ago

Unfortunately that will not work in my situation. A 3rd party application is making the INSERT into my DB, and I need to actively run this Trigger when this happens.

Collectives™ on Stack Overflow

MySQL Trigger Not Functioning

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related