MySQL Forums
Forum List  »  Triggers

Re: Trigger HelpPlease
Posted by: Peter Brawley
Date: July 08, 2015 09:42AM

Multi-line stored routines need to be surrounded by delimiter directives (so the engine can parse them), eg ...

drop trigger if exists airfield_insert;
delimiter go
create trigger ...
go
delimiter ;

Options: ReplyQuote


Subject
Views
Written By
Posted
1746
July 07, 2015 04:33PM
1126
July 07, 2015 10:26PM
1233
July 08, 2015 07:00AM
Re: Trigger HelpPlease
1077
July 08, 2015 09:42AM
938
July 15, 2015 03:50AM
853
July 15, 2015 10:00AM


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.