TRIGGER Help

What's wrong with this script?
I got error:
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 'SET NEW.TSHP = 0' at line 5

CREATE TRIGGER shipumw01 BEFORE INSERT ON umw_ship_sol
FOR EACH ROW
BEGIN
IF NEW.L0 <> 0 THEN
SET NEW.TSHP = 0;
SET NEW.LSHP = 0;
SET NEW.NSHP = 0;
SET NEW.BO = NEW.OQTY;
SET NEW.ST = 'NS';
END IF;
END

Re: TRIGGER Help

Bre-x wrote in news:c714902a-93d8-49a8-b862-
f8e4ad6d8bcb@e23g2000prf.googlegroups.com:

> What's wrong with this script?
> I got error:
> 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 'SET NEW.TSHP = 0' at line 5
>
> CREATE TRIGGER shipumw01 BEFORE INSERT ON umw_ship_sol
> FOR EACH ROW
> BEGIN
> IF NEW.L0 <> 0 THEN
> SET NEW.TSHP = 0;
> SET NEW.LSHP = 0;
> SET NEW.NSHP = 0;
> SET NEW.BO = NEW.OQTY;
> SET NEW.ST = 'NS';
> END IF;
> END
>

Answered in comp.databases.mysql over an hour ago. Where you been? And
don't multipost!