
create table test_table (id int, test_data varchar(36)) engine=innodb;

insert into test_table(id, test_data)
select id, test_data
    from (
        with recursive data_generator(id, test_data) as (
                select 1 as id, uuid() as test_data
                union all
                select id + 1, uuid() from data_generator where id < 500000
            )
        select * from data_generator
    ) as a;

commit;