Trigger don't work

Question

Need some help here :)

 DELIMITER |
    CREATE TRIGGER update_tab2 AFTER INSERT ON contacts
        FOR EACH ROW
                BEGIN
                IF(NEW.city= 'LA') THEN
                    SET  NEW.tag = "HI LA";
                END IF;
            END;
     |
    DELIMITER ;

This trigger should update me the tag column when the user complete a html "city" form with LA. The trigger is correct (the syntax I mean, but just don't put anything in the "tag" column.

Can anyone give me a hint about what is wrong? :)

Answer 1

You need a before insert trigger if you want to change the data being inserted:

DELIMITER |
CREATE TRIGGER update_tab2 BEFORE INSERT ON contacts
    FOR EACH ROW
            BEGIN
            IF(NEW.city = 'LA') THEN
                SET  NEW.tag = "HI LA";
            END IF;
        END;
 |
DELIMITER ;