CREATE PROCEDURE appenddata()
BEGIN
	DECLARE done INT DEFAULT 0;
	DECLARE a,b INT;
	DECLARE lstart, lend INT;
	DECLARE c VARCHAR(20);
	DECLARE cur CURSOR FOR SELECT f1,f2,f3 FROM tmp_info;
	DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = 1;

	OPEN cur;
	read_loop: LOOP

		FETCH cur INTO a, b, c;
		IF done THEN
			LEAVE read_loop;
		END IF;
		-- Keep all using the same format
		SET c = REPLACE(c, ";", ",");
		SET c = REPLACE(c, "-", ",");
		SET lstart = 1;
		SET lend = LOCATE(",", c, lstart);
		WHILE lend > 0 DO
			INSERT INTO t_info(f1, f2, f3) VALUES (a, b, SUBSTRING(c, lstart, lend-lstart));
			SET lstart = lend+1;
			SET lend = LOCATE(",", c, lstart);
		END WHILE;
		IF c <> "" THEN
			INSERT INTO t_info(f1, f2, f3) VALUES (a, b, SUBSTRING(c, lstart));
		END IF;
		
	END LOOP;
	CLOSE cur;
END;