Copying One Table Into Another Using MySQL
// February 17th, 2009 // Database, MySQL
I wanted to copy the contents of an existing table I had which only had certain fields populated.
INSERT INTO new-table (field1, field2)
SELECT distinct original-field1, original-field2
FROM existing-table WHERE original-field1 is not null