trigger

[charith ekanayake]

I'm having trouble with the following mysql trigger can someone help me

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;

create table Product
(
pid bigint unsigned not null auto_increment
username varchar(10),
start_date datetime,
pd_image BLOB,
pd_details TEXT,
current_bid float(10,2) default 0.00,

primary key(pid),
foreign key(username) references User(username)
);

create table temp
(

username varchar(10),

pd_image BLOB,
pd_details TEXT,


);