Thanks for the help. I tried your suggestion but only got 1 row inserted in the test table.
Luis -----Original Message----- From: Olof Tjerngren [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 3:01 AM To: Luis Lebron Cc: Mysql (E-mail) Subject: Re: Creating random data in a test table based on an existing table 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 10000; MvH, Luis Lebron wrote: > 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...). Is it possible to do this via a MySQL query? > > Luis R. Lebron > Sigmatech, Inc >