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';
IF OLD.name = 'base' THEN
SIGNAL mysig SET MESSAGE_TEXT='base row removal is not allowed';
END IF;
END
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[email protected]
