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;