MySQL trigger for updating a particular record column value

Question

I have been tried mysql trigger to set a field to value 1, if there is any update action happened in any column of the record.

I am newbie in trigger, so help me to set a value to 1, if updated record

Thanks

Andy Hall · Accepted Answer · 2015-02-08 16:24:06Z

1

CREATE TRIGGER t_name AFTER INSERT ON table_name

SET @attribute_name = 1;

answered Feb 8, 2015 at 16:24

Andy Hall

4641 gold badge5 silver badges14 bronze badges

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

Comments

Mureinik · Accepted Answer · 2015-02-08 16:21:37Z

0

This looks like a classic usecase for a before update trigger:

delimiter //
CREATE TRIGGER mytable_upd_trg 
BEFORE UPDATE ON mytable
FOR EACH ROW
BEGIN
    SET NEW.special_field = 1;
END;//
delimiter ;

answered Feb 8, 2015 at 16:21

Mureinik

316k54 gold badges402 silver badges406 bronze badges