Re: Trigger error with update
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
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.