MySQL – Trigger

for old value use OLD.column_name

for new value use NWE.column_name

 

// — before trigger

delimiter $$
CREATE TRIGGER your_trigger_name
BEFORE UPDATE ON table_1
FOR EACH ROW
BEGIN
INSERT into table_log
(`id`, `mobnum`)
VALUES (OLD.id, OLD.mobnum);
END$$

 

// — after trigger

delimiter $$
CREATE TRIGGER your_trigger_name
after UPDATE ON table_1
FOR EACH ROW
BEGIN
INSERT into table_log
(`id`, `mobnum`)
VALUES (OLD.id, OLD.mobnum);
END$$

 

 

delimiter $$
CREATE TRIGGER before_tbl_attempted_update
BEFORE UPDATE ON tbl_attempted
FOR EACH ROW
BEGIN
INSERT into tbl_attempted_log
(`attempted_id`, `mobnum`, `que_id`, `cat_id`, `answer`, `attemp`, `star`, `temp`, `date_time`)
VALUES (OLD.id, OLD.mobnum, OLD.que_id, OLD.cat_id, OLD.answer, OLD.attemp, OLD.star, OLD.temp, OLD.date_time);
END$$

 

—- delete tigger
DROP TRIGGER before_tbl_attempted_update;