Make SQLITE Trigger work with MYSQL

Question

How do I make this sqlite trigger compatible with MYSQL, I have never used triggers with MYSQL and I'm confused.

             CREATE TRIGGER IF NOT EXISTS update_this AFTER INSERT ON this
             BEGIN
             UPDATE `another` SET `something` = `something` + new.number;
             END;

Solution :

     delimiter |
     CREATE TRIGGER update_this AFTER INSERT ON this`
     FOR EACH ROW BEGIN
     UPDATE `another` SET `something` = `something` + NEW.something WHERE `id`= NEW.id;
     END;
     |    
     delimiter ;

CREATE TRIGGER syntax - dev.mysql.com/doc/refman/5.5/en/create-trigger.html — Devart
– Devart, Commented Feb 16, 2012 at 8:29

juergen d · Accepted Answer · 2012-02-16 08:42:03Z

1

Unverified:

delimiter //
    CREATE TRIGGER update_this AFTER INSERT ON your_table
    BEGIN
        UPDATE `another` SET `something` = `something` + new.number;
    END;
//

answered Feb 16, 2012 at 8:42

juergen d

205k40 gold badges303 silver badges377 bronze badges

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

1 Comment

dead Over a year ago

I played around with it and found a solution, thanks everyone for trying

Collectives™ on Stack Overflow

Make SQLITE Trigger work with MYSQL

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