MySQL Forums
Forum List  »  Newbie

Re: INSERT, UPDATE, or DELETE based on a JOIN
Posted by: Rick James
Date: May 15, 2013 08:23PM

I assume the IBM machine is not running MySQL?

There is no way to JOIN between two machines running two different database engines.

I would get both sets of data on the same machine in the same engine. Then do JOINs to list the ids to delete, the ids+values to change, and the ids+values to change. I would do this in some programming language so I could output 3 SQL statements (or sets of statements) that would do INSERT, DELETE, UPDATE. Then I would execute them (remotely, if necessary) to do the task.

Lookup the INSERT and UPDATE syntax for "multi-table" operations. There are probably similar syntaxes for the IBM box.

Options: ReplyQuote


Subject
Written By
Posted
Re: INSERT, UPDATE, or DELETE based on a JOIN
May 15, 2013 08:23PM


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.