gFTkPnK2

1CREATE PROCEDURE fill_gt (IN cnt INT)
2BEGIN
3  DROP TABLE IF EXISTS gt;
4 
5  CREATE TABLE gt (i int(10) unsigned NOT NULL, c char(50) NOT NULL) ENGINE=MyISAM DEFAULT CHARSET=latin1;
6 
7  DECLARE i INT;
8  SET i = 0
9  
10  WHILE i < cnt0 DO
11    INSERT INTO gt VALUES (i, 'a');
12  END WHILE;
13   
14END
15
16
17SET @cnt = 1000 * 1000;
18EXECUTE fill_gt  USING @cnt;