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

Filed under:
|
|

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

Related posts about mysql

Related posts about triggers