How about somethine like this as a starting point:
insert into testuser (firstname,lastname) select
u1.firstname,u2.lastname from user u1, user u2 order by rand() limit 1;
MvH,
Luis Lebron wrote:
I have an users table for a php application that I am programming. The
current users table has
I have an users table for a php application that I am programming. The
current users table has about 1500 records. I would like to create a test
table (i.e. users_test) with 10,000 records based on random data from the
first table (i.e. random first name combined with a random last name,
etc...). I