Inserting Duplicate records

See more:

PHP

MySQL

Hi all,
I have written a stored procedure which uses cursor to fetch a column and insert into another table.


Below is my code,

delimiter //
CREATE PROCEDURE curdemo()
BEGIN
  DECLARE done INT DEFAULT 0;  
  DECLARE a INT;
  DECLARE cur1 CURSOR FOR SELECT intCid FROM tblcountries; 
  DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;
  OPEN cur1; 
  while not done do
          FETCH cur1 INTO a; 
		INSERT INTO t1(n1) VALUES (a);   
  END while;
  CLOSE cur1;
  
END
//

My problem is last record alone getting inserted twice. How to solve this?