Re: How i can reject a row in a trigger?

[Bob Field]

The solution I have worked out to abort a deletion via a before delete trigger is this:

DELIMITER $$
CREATE TRIGGER triggername BEFORE DELETE ON yourtable
FOR EACH ROW
BEGIN
  DECLARE temp int;
  SELECT `DELETE aborted` INTO temp FROM yourtable;
END$$
DELIMITER ;

This should abort the delete and leave the row(s) intact. Selecting a non-existent column name works to raise an error in triggers and stored routines. The bad column name can double as your error message. You can wrap whatever conditional you want around the SELECT statement.