[LordJZ]

delimiter|
CREATE TRIGGER points_limiter AFTER UPDATE ON points
  IF (NEW.points >= 100)
  THEN
     UPDATE points SET points = 0 WHERE id = NEW.id;
  END IF;
END
|

но это криво