Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Director General: NEFACOMP
t;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> 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 Sys

Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Nobody
- Original 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) an

[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