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 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?
Sheesh. Nevermind. INSERT INTO table (column) SELECT DISTINCT column2 FROM table2; If you want to figure something out yourself, post a question to a mailing list. You'll find the answer within 30 seconds of hitting "SEND." -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]