Re: Copying distinct data to a new table

2003-08-21 Thread Martin Gainty
Glad that helped! -M - Original Message - From: "Dan Jones" <[EMAIL PROTECTED]> To: "MySQL Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, August 21, 2003 5:46 PM Subject: Re: Copying distinct data to a new table > On Thu, 2003-08-21 at 20:09, Dan

Re: Copying distinct data to a new table

2003-08-21 Thread Dan Jones
On Thu, 2003-08-21 at 20:09, Dan Jones wrote: > I'm attempting to normalize a database that was originally created as a > flat file. I want to extract distinct values from a table and insert > them as new entries into a new table. Unless I'm missing something, > INSERT doesn't allow you to SELECT

Re: Copying distinct data to a new table

2003-08-21 Thread Rajesh Kumar
Dan Jones unknowingly asked us: I'm attempting to normalize a database that was originally created as a flat file. I want to extract distinct values from a table and insert them as new entries into a new table. Unless I'm missing something, INSERT doesn't allow you to SELECT data from another tab