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