create table n
select 0 n union all select 1 union all select 2 union all select 3 union all select 4 union all
select 5 union all select 6 union all select 7 union all select 8 union all select 9;

create table data
select 
  @n:=((n3.n*10+n2.n)*10+n1.n)+1 id, 
  concat('ivan', @n) name,
  concat('text', @n) value
from n n1,n n2,n n3;

drop table n;

select * from data;

create temorary table t1(n int); insert t1(n) values (0),(1),...(9);
create temorary table t2 select * from t1;
create temorary table t3 select * from t1;
create temorary table t4 select * from t1;

select ...
from t1,t2,t3,t4;

drop temporary table t1,t2,t3,t4;