1. drop table if exists foo;
    2. create table foo
    3. (
    4. id int unsigned not null auto_increment primary key,
    5. val smallint unsigned not null default 0
    6. )
    7. engine=innodb;
    9. drop procedure if exists load_foo_test_data;
    11. delimiter #
    12. create procedure load_foo_test_data()
    13. begin
    15. declare v_max int unsigned default 1000;
    16. declare v_counter int unsigned default 0;
    18.   truncate table foo;
    19.   start transaction;
    20.   while v_counter < v_max do
    21.     insert into foo (val) values ( floor(0 + (rand() * 65535)) );
    22.     set v_counter=v_counter+1;
    23.   end while;
    24.   commit;
    25. end #
    27. delimiter ;
    29. call load_foo_test_data();
    31. select * from foo order by id;