MySQL Forums
Forum List  »  Newbie

Help find missing rows
Posted by: carlhe
Date: May 12, 2005 08:03AM

I have the same database & table on two unix servers that are in a remote location. One table has a couple fewer rows in it than the other. I need to find out which rows they are. I am pretty familier with Sql server syntax, but cannot find the corresponding syntax for doing this in mysql.

Server a has the correct amount of rows (1 million)
Server b has 999,500 rows.
I was going to use the following query to find the missing rows:
Select a.pkey
from table a
outer join <server>.<db>.<owner>.table b
where b.pkey is null

This query doesnt seem to work in mysql. Would someone please advise the correct MySql syntax for finding these missing rows? I am especially stumped on how to reference a table on another server from my local server.
Thank you!!

Options: ReplyQuote


Subject
Written By
Posted
Help find missing rows
May 12, 2005 08: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.