MySQL Forums
Forum List  »  Triggers

Re: trigger
Posted by: irek kordirko
Date: January 24, 2012 03:54PM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
2194
January 24, 2012 08:20AM
Re: trigger
1124
January 24, 2012 03:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.