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 |

No comments:

Post a Comment