$ nano employee_update_trg.sql create trigger employee_update_trg after update on employee begin update employee set updatedon = datetime('NOW') where rowid = new.rowid; end;