MySQL Forums
Forum List  »  Triggers

Re: Trigger error with update
Posted by: Mike Kruckenberg
Date: April 12, 2006 11:25AM

Well, you have the end in there, but without setting the delimiter to something else the client is seeing the ; in the middle of your trigger and attempting to process that. add a "delimiter ##" statement up front and change the ; after end to ##. Don't forget to set your delimiter back with "delimiter ;"

Mike Kruckenberg
Co-author of Pro MySQL (Apress)
http://mike.kruckenberg.com

Options: ReplyQuote


Subject
Views
Written By
Posted
7162
April 12, 2006 09:28AM
2208
April 12, 2006 10:19AM
Re: Trigger error with update
2260
April 12, 2006 11:25AM
2260
April 12, 2006 01:01PM
2079
April 12, 2006 01:17PM
2164
April 12, 2006 02:23PM


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.