Re: Validation Trigger

[Devart Team]

DELIMITER $$

CREATE TRIGGER trigger1
  BEFORE INSERT
  ON invoice_details
  FOR EACH ROW
BEGIN
  IF NEW.due_date <= NOW() OR NEW.invoice_date <= NOW() OR NEW.shipping_total <=0 OR NEW.order_total <=0 OR NEW.total_cost <=0 THEN
    SIGNAL SQLSTATE '45000' SET MESSAGE_TEXT = 'Wrong values for invoice_details';
  END IF;
END$$

DELIMITER ;

From the reference - To signal a generic SQLSTATE value, use '45000', which means “unhandled user-defined exception.”

Devart Company,
MySQL management tools
http://www.devart.com/dbforge/mysql/