Bug #10401 TRIGGERS NOT FIRING.AFTER INSERT..BEFORE INSERT
Submitted: 6 May 2005 6:17 Modified: 6 May 2005 6:48
Reporter: raj k Email Updates:
Status: Duplicate Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S1 (Critical)
Version:mysql 5.0.3 beta OS:Windows (windows)
Assigned to: 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