Re: trigger

[Devart Team]

Thriggers cannot modify the same table, but try to use BEFORE triggers to change NEW values.

CREATE TABLE t(
  id INT(11) NOT NULL AUTO_INCREMENT,
  active BIT(1) DEFAULT NULL,
  end DATE DEFAULT NULL,
  PRIMARY KEY (id)
);

DELIMITER $$

CREATE TRIGGER trigger1
BEFORE UPDATE
ON t
FOR EACH ROW
BEGIN
  IF NEW.end IS NOT NULL THEN
    SET NEW.active = 1;
  END IF;
END
$$

CREATE TRIGGER trigger2
BEFORE INSERT
ON t
FOR EACH ROW
BEGIN
  IF NEW.end IS NOT NULL THEN
    SET NEW.active = 1;
  END IF;
END
$$

DELIMITER ;

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