Hi,
usually a procure for mysql quick insert data can be done like this:
DELIMITER $$
DROP PROCEDURE IF EXISTS sampleData$$
CREATE PROCEDURE sampleData()
BEGIN
DECLARE x INT;
DECLARE thedate DATETIME;
SET thedate = '2012-12-01';
SET x = 1;
WHILE x <= 6 DO
SET x = x + 1;
SET thedate = DATE_ADD(thedate, INTERVAL 1 DAY);
INSERT INTO `temptable` (`x`, `thedate`)
VALUES (x, thedate);
END WHILE;
END$$
DELIMITER ;
best,
tecbea
