MySQL Forums
Forum List  »  InnoDB

Combining two identical tables with matching primary keys but unique data
Posted by: Robert Herbst
Date: January 27, 2009 12:20AM

Hi there,

We recently split our database in two for testing purposes and now need to combine the two again. I am completely stumped as to how to do this using SQL. If the worst comes to the worst I'll have to write a C# program to evaluate and combine data effectively.

The problem is that we have two sets of data for this identical table and those two sets are using the same primary keys.

Is there any simple way to create a SELECT query that will select the unique data from one table without it's primary key and insert it into the other table?

Both tables' primary key are AUTO-INCREMENT.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Combining two identical tables with matching primary keys but unique data
5163
January 27, 2009 12:20AM


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.