Re: Creating random data in a test table based on an existing tab le

2003-11-13 Thread Olof Tjerngren
Hi, I tried it in 4.0 and got the desired result - but at least the select part should not depend on version, as long as it's recent. The select should return all combinations of first and last names available in the source table ordered by random to be more interesting. You can try that by its

RE: Creating random data in a test table based on an existing tab le

2003-11-11 Thread Luis Lebron
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