Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Nobody
Message - From: PAUL MENARD [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 09, 2003 5:21 PM Subject: [MYSQL] Combine tables from two different systems Hello All, I have two system, we shall call then system A (OLD) and system B (NEW), running MySQL that I want to combine

Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Director General: NEFACOMP
] Sent: Friday, October 10, 2003 14:40 Subject: Re: [MYSQL] Combine tables from two different systems Hi Paul If all the tables have a primary key set, you can do an INSERT IGNORE from the tables in System A to the tables in System B (either manually or write a script). Any rows form System

[MYSQL] Combine tables from two different systems

2003-10-09 Thread PAUL MENARD
Hello All, I have two system, we shall call then system A (OLD) and system B (NEW), running MySQL that I want to combine their tables. The system B is the newer and most accurate. The table structure is the exact same. Some of the rows in system B (NEW) tables are also in system A (OLD). For