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..