MySQL Forums
Forum List  »  Triggers

Re: Cant get my Trigger to work
Posted by: Phillip Ward
Date: July 18, 2013 06:09AM


declare p varchar(80)
set p := (SELECT filepath FROM content_type_importcsv join files where NEW.content_type_importcsv.field_csv1_fid = files.fid)
set NEW.field_csvfilepath_value = p
I'm pretty sure you need semi-colons (";") at the end of each individual statement.

Regards, Phill W.

Options: ReplyQuote

Written By
July 18, 2013 02:55AM
Re: Cant get my Trigger to work
July 18, 2013 06:09AM

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.