MySQL Forums
Forum List  »  Newbie

Re: Merging two tables with primary keys
Posted by: Phillip Ward
Date: March 27, 2018 04:37AM

Quote

... when I try to combine them it finds identical PATNO (PK) values ...

... and what do you want to do with each of those duplicates?

* Keep the record you already have and ignore the one being merged?
* Keep the record being merged and drop the one you already have?
* Update some or all of the fields from the merging record into the one you already have?
* Something else entirely?

Regards,
Phill W.

Options: ReplyQuote


Subject
Written By
Posted
Re: Merging two tables with primary keys
March 27, 2018 04:37AM


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.