MySQL Forums
Forum List  »  Triggers

Advanced Search
New Topic

DB to DB updating
Posted by: Ken Sullivan
Date: June 30, 2011 05:04PM

Ok, I have 2 different databases on the same server. I am trying to add information from DB1 into DB2. I am using the phpMyAdmin to try and update one DB from the other DB. Everything I have tried gives me an error. How would I best update DB2.Table.Field with DB1.Table.Field so that any data from DB1 that is not in DB2 will be added to DB2?

UPDATE DB2.Table.Field WITH DB1.Table.Field WHERE DB2.Table.Field <> DB1.Table.Field

Both Fields are suppose to be UNIQUE and not be able to have any duplicates.

Any help in creating the SQL statement would be appreciated.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
DB to DB updating
2140
Ken Sullivan
June 30, 2011 05:04PM
Re: DB to DB updating
950
Peter Brawley
July 01, 2011 11:05AM


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.