Bug #10401 TRIGGERS NOT FIRING.AFTER INSERT..BEFORE INSERT

• Submitted: 6 May 2005 6:17
• Modified: 6 May 2005 6:48
• Reporter: raj k
• Status: Duplicate
• Category: MySQL Server: Command-line Clients
• Severity: S1 (Critical)
• Version: mysql 5.0.3 beta
• OS: Windows (windows)
• CPU Architecture: Any

[6 May 2005 6:17] raj k

Description:
CREATE TRIGGER new AFTER INSERT ON table1 FOR EACH ROW
BEGIN
   DECLARE DAY1  VARCHAR(8);
   DECLARE i DOUBLE;  
SET I = 1;
  WHILE(I <= 7) DO
  
  IF I=1 THEN
    SET DAY1 ='MON';
  END IF;

  IF I=2 THEN
   SET  DAY1 ='TUE';
  END IF;

  IF I=3 THEN
   SET  DAY1 ='WED';
  END IF;

  IF I=4 THEN
    SET DAY1 ='THU';
  END IF;

  IF I=5 THEN
   SET DAY1 ='FRI';
  END IF;

  IF I=6 THEN
    SET DAY1 ='SAT';
  END IF;

  IF I=7 THEN
    SET DAY1 ='SUN';
  END IF;

   INSERT INTO table2 (daay,name)
       ) VALUES(day1,raj);
  SET I = I+1;
END WHILE;

END ;
this trigger not at all working...

How to repeat:
triggers are not working