Error 1064 while defining a trigger

Hi all,

I am trying to define the following trigger in mysql.



CREATE TRIGGER deltot before INSERT ON ts1
for each row BEGIN
delete from ts1 where activity_details="totals";
END|

When I execute this, I get a 1064 error. It seems to be an error with
the sql that I have written but I am unable to find the problem.

Any one any thoughts?
Pranav


--
MySQL Windows Mailing List
For list archives: http://lists.mysql.com/win32
To unsubscribe: http://lists.mysql.com/win32?unsub=gcdmw-win32@m.gmane.org