Re: ERROR 1442 - Cannot update table which has trigger

[Devart Team]

It is a restriction. You cannot modify trigger's table. Try to use something like this -

CREATE TRIGGER trigger1
  BEFORE UPDATE
  ON driver
  FOR EACH ROW
BEGIN
  IF NEW.break_finish_time >= NOW() AND NEW.break_start_time <= NOW() THEN
    SET NEW.is_available = 0;
  END IF;
END

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