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 doesn't allow you to create new rows.
I could do a SELECT DISTINCT INTO OUTFILE, then LOAD DATA INFILE but that seems rather cumbersome. Is there a straightforward way to do this? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]