Re: Trigger to copy row before delete

[Peter Brawley]

To combine Insert...Select... with specific column arguments, you will need to forego Select * in favour of specific column arguments eg ...

insert into tblname (cola,colb,...)
select vala,valb,...,'now(),'delete' from othertbl;