MySQL Forums
Forum List  »  Newbie

Re: Compare identical tables and return the difference
Posted by: Marvin Eads
Date: May 20, 2005 09:03AM

In this case only the primary key. Off the top of my head, you could join all the fields then check for nulls across all the fields with one long WHERE statement joined by OR. Seems like it wouldnt be very efficient but I dont know of a way to compare records.

Options: ReplyQuote


Subject
Written By
Posted
Re: Compare identical tables and return the difference
May 20, 2005 09:03AM


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.