DELIMITER ;;
CREATE PROCEDURE t1data()
BEGIN
DECLARE i INT DEFAULT 0;
SET i=1;
WHILE i <= 10000 DO
INSERT INTO t1(`c1`,`c2`,`c3`,`c4`) VALUES(RAND()*10000, RAND()*10000, RAND()*10000, RAND()*10000);
SET i=i+1;
END WHILE;
END;;
CALL t1data();