MySQL Forums
Forum List  »  Triggers

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

Quote

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


Subject
Views
Written By
Posted
2047
July 18, 2013 02:55AM
Re: Cant get my Trigger to work
925
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.