Is the syntax written in descrition is correct for MySQL Triggers? will it work?
Posted
by Parth
on Stack Overflow
See other posts from Stack Overflow
or by Parth
Published on 2010-03-26T04:43:22Z
Indexed on
2010/03/26
7:13 UTC
Read the original article
Hit count: 152
Is the syntax written in descrition is correct for MySQL Triggers? will it work?
CREATE OR REPLACE TRIGGER myTableAuditTrigger
2 AFTER INSERT OR DELETE OR UPDATE ON myTable
3 FOR EACH ROW
4 BEGIN
5 IF INSERTING THEN
6 INSERT INTO myTableAudit (id, Operation, NewName, NewPhone)
7 VALUES (1, 'Insert ', :NEW.Name, :NEW.PhoneNo);
8 ELSIF DELETING THEN
9 INSERT INTO myTableAudit (id, Operation, OldName, OldPhone)
10 VALUES (1, 'Delete ', :OLD.Name, :OLD.PhoneNo);
11 ELSIF UPDATING THEN
12 INSERT INTO myTableAudit (id, Operation,
13 OldName, OldPhone, NewName, NewPhone)
14 VALUES (1, 'Update ',
15 :OLD.Name, :OLD.PhoneNo, :NEW.Name, :NEW.PhoneNo);
16 END IF;
17 END;
18 /
© Stack Overflow or respective owner