programming: create triggers

Showing posts with label create triggers. Show all posts

Monday, February 27, 2012

create mysql triggers

table names
testing.name
testing_T.fullname

CREATE TRIGGER addnm AFTER INSERT ON testing
FOR EACH ROW BEGIN
INSERT INTO testing_T SET fullname = NEW.name;
END;

delimiter |