Re: trigger

[irek kordirko]

What exactly kind of trouble do you have ?
Compilation errors ?
Runtime errors ?

If you cannot compile it, then change a delimiter with 'delimiter' comand and place a semicolon at the end of INSERT statement:

delimiter //
create trigger posting
before delete on temp
for each row
begin

insert into Product
(username,start_date,pd_image,pd_details)

values(old.username,now(),old.pd_image,old.pd_details);
end; 
//
delimiter ;

If there is other kind of error, then please explain.