tags:

views:

47

answers:

0

am using mysql 5.1..am wrote trigger after update..

CREATE TRIGGER myTrigger

AFTER UPDATE ON employee FOR EACH ROW BEGIN INSERT into transaction_log values(12,'free'); END . . .

here am using 2 tables..if update the data on employee table.value insert another table(transaction_log).but its not working..