Trigger Lock table

System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz Trigger: create trigger CustomerHistoryUPD BEFORE Update on Customer For each ROW BEGIN insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_I

Trigger Lock table

System Linux SUSE 9.1 with mysql-max-5.0.11-beta-linux-i686.tar.gz Trigger: create trigger CustomerHistoryUPD BEFORE Update on Customer For each ROW BEGIN insert into CustomerHist select * from Customer where FD_ID = OLD.FD_ID; Update CustomerHist set HistDate = NOW() where FD_ID = OLD.FD_I