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 [at] m.gmane.org
Pranav Lal [ Do, 08 September 2005 18:21 ] [ ID #957621 ]
Datenbanken » gmane.comp.db.mysql.windows » Error 1064 while defining a trigger

Vorheriges Thema: MySQL causes a BSOD on my Windows XP when the table files are "toobig"
Nächstes Thema: MySQL Crash Diagnosis