MySQL Forums
Forum List  »  Stored Procedures

Error Code : 1064
Posted by: Fred Knaut
Date: September 11, 2008 06:49AM

Getting the following error:
Error Code : 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'END' at line 5

With the following trigger:
CREATE TRIGGER `polymer`.`Avail_Weight`
BEFORE INSERT ON `polymer`.`inventory`
FOR EACH ROW BEGIN
SET NEW.Available_Weight = NEW.Raw_Weight - NEW.Processed_Weight
END ;

Why?

Options: ReplyQuote


Subject
Views
Written By
Posted
Error Code : 1064
30679
September 11, 2008 06:49AM
11301
April 27, 2009 01:30AM
8622
May 03, 2009 08:38AM
5689
May 03, 2009 10:13AM
5040
May 03, 2009 12:44PM


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.