MySQL Forums
Forum List  »  Newbie

Re: how do I merge two columns and auto increment primary key after using JOIN in my table?
Posted by: Peter Brawley
Date: September 27, 2020 03:48PM

> On matching I want to merge these two matched columen shown in **

Entirely unclear. What is meant by "merge"?

> Also for non-matched items in Table B, I want to autoincrement Account_NUM

Also unclear. The requirement is to replace tableB.account_num values with sequential ints in rows where tableB.account_num does not exist in tableA? Is there, in this requirement, a rule about whether such values should or should not match tableA.account_num values?

Looks like a (somewhat peculiar) homework assignment. Is it?



Edited 1 time(s). Last edit at 09/27/2020 04:21PM by Peter Brawley.

Options: ReplyQuote


Subject
Written By
Posted
Re: how do I merge two columns and auto increment primary key after using JOIN in my table?
September 27, 2020 03:48PM


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.