I need to create a new table with data from an existing table. The new table needs a unique index (multi-column) that is not in the existing table. Therefore, many records I will not want to migrate because they would be dups to the new table. I've defined the new table structure, but don't know how to go about copying over the data. Insert Into does not seem to work or I don't have correct syntax.
Much appreciate the right MySql statements to accomplish this.