Re: SOS mysql signal syntax error

2009-05-20 Thread Alex Katebi
kat...@gmail.com] > Sent: Wednesday, May 20, 2009 10:58 AM > To: mysql > Subject: SOS mysql signal syntax error > > Hi Folks, > > I am getting syntax error with the mysql signal. I have a trigger > that needs a signal for raising an error condition if a row with > specific v

RE: SOS mysql signal syntax error

2009-05-20 Thread Gavin Towey
l Message- From: Alex Katebi [mailto:alex.kat...@gmail.com] Sent: Wednesday, May 20, 2009 10:58 AM To: mysql Subject: SOS mysql signal syntax error Hi Folks, I am getting syntax error with the mysql signal. I have a trigger that needs a signal for raising an error condition if a row with s

SOS mysql signal syntax error

2009-05-20 Thread Alex Katebi
Hi Folks, I am getting syntax error with the mysql signal. I have a trigger that needs a signal for raising an error condition if a row with specific value is removed. CREATE TRIGGER my_trig BEFORE DELETE ON my_tbl FOR EACH ROW BEGIN DECLARE mysig CONDITION FOR SQLSTATE '45000';