New table with unique indexes from existing table
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.
Thanks greatly,
Lyle
Subject
Written By
Posted
New table with unique indexes from existing table
May 15, 2014 12:21AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.