rembrechts
Programmer
I want to change two fields in a table when a record is created. I've written a trigger that should do the trick, but it won't. Can somebody help me?
Code:
create trigger Insert_TS_TBL_Unfinished before INSERT on TBL_Unfinished
FOR EACH ROW
BEGIN
set new.Recordcreated_servertime = now();
SET new.Recordmodified_Servertime = now();
END