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 table for
insertion, and UPDATE
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
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
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 Jones wrote:
I'm attempting to normalize