Duplicating updated row on another table via trigger in mysql

Question

I have two tables (A & B). I want to duplicate a row from Table A to Table B when a value of a column in Table A is equal to x, how would I do that using a trigger? Table A is constantly updating, via query in my vb.net program, until such time that a column in Table A equals to x, I want to copy that row into Table B, not via another query on vb.net but via mysql database trigger. Any input would be appreciated.

Thanks

Justjyde · Accepted Answer · 2015-03-26 14:56:42Z

1

This works for mySQL. I've tried it out.

CREATE TRIGGER `tableA_AUPD` AFTER UPDATE ON `tbla` FOR EACH ROW
begin   
    IF (NEW.fldx = 'x') THEN
        INSERT INTO tblb (fldb0,fldb1,fldx) VALUES(NEW.flda0,NEW.flda1,NEW.fldx);
    END IF;
end

answered Mar 26, 2015 at 14:56

Justjyde

3221 gold badge3 silver badges13 bronze badges

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

Collectives™ on Stack Overflow

Duplicating updated row on another table via trigger in mysql

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