使SQLITE触发器与MYSQL一起工作 - Make SQLITE Trigger work with MYSQL

Make SQLITE Trigger work with MYSQL

我如何使这个sqlite触发器与MYSQL兼容，我从未将触发器与MYSQL一起使用过，我很困惑。

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

解决方案：

     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 ;

未验证：

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