Please verify the trigger created below for delete is correct or not?
Posted
by Parth
on Stack Overflow
See other posts from Stack Overflow
or by Parth
Published on 2010-04-01T05:32:53Z
Indexed on
2010/04/01
5:33 UTC
Read the original article
Hit count: 184
Please verify the trigger created below for delete is correct or not?
Its for the insertion of every field of deleted row in audit table.. Please reply whether this trigger will work for me?
delimiter //
CREATE TRIGGER audit_menu BEFORE DELETE ON menu
FOR EACH ROW
BEGIN
INSERT INTO audit (menuid, field, oldvalue, changedone) VALUES
(OLD.menuid, 'name', OLD.name, UNIX_TIMESTAMP() ),
(OLD.menuid, 'age', OLD.age, UNIX_TIMESTAMP() ),
(OLD.menuid, 'address', OLD.address, UNIX_TIMESTAMP() ),
(OLD.menuid, 'sex', OLD.sex, UNIX_TIMESTAMP() ),
(OLD.menuid, 'town', OLD.town, UNIX_TIMESTAMP() )
END;//
delimiter ;
© Stack Overflow or respective owner