如何通过一个sql请求向mysql表中插入一定数量的行

是的,你可以这样做,也许对你有帮助。

drop procedure if exists load_foo_test_data;

delimiter #
create procedure load_foo_test_data()
begin

declare v_max int unsigned default 1000;
declare v_counter int unsigned default 0;

    truncate table foo;
    start transaction;
    while v_counter < v_max do
        insert into foo (val) values ( floor(0 + (rand() * 65535)) );
        set v_counter=v_counter+1;
    end while;
    commit;
end #
delimiter ;

call load_foo_test_data();

select * from foo order by id;