MySQL Forums
Forum List  »  Newbie

New table with unique indexes from existing table
Posted by: Lyle Holcomb
Date: May 15, 2014 12:21AM

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

Options: ReplyQuote


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.