drop database if exists test42908;
create database test42908;
use test42908;

create table sbtest (
          `id` int(10) unsigned NOT NULL auto_increment,
          `k` int(10) unsigned NOT NULL default '0',
          `c` char(120) NOT NULL default '',
          `pad` char(60) NOT NULL default '',
          PRIMARY KEY  (`id`),
          KEY `k` (`k`)
        ) ENGINE=InnoDB;


delimiter //
create procedure fill_tb()
begin
        DECLARE my_val INTEGER DEFAULT 1;
          wl_loop: WHILE my_val <= 1000000 DO
                INSERT INTO sbtest ( k, c, pad )
                VALUES( 0, '', 'qqqqqqqqqqwwwwwwwwwweeeeeeeeeerrrrrrrrrrtttttttttt' );
                SET my_val = my_val + 1;
        END WHILE wl_loop;
END //
delimiter ;

call fill_tb();