Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Nobody 
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 A that already have a System B equivalent will be
silently dropped and only those that do not have an equivalent will be
written.

e.g. INSERT IGNORE INTO system_b.table_n (columns)
SELECT columns FROM system_a.table_n

HTH
Rory McKinley
Nebula Solutions
082 857 2391
[EMAIL PROTECTED]
There are 10 kinds of people in this world,
those who understand binary and those who don't (Unknown)
- 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) 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 those rows I want
to leave the system B data unchanged.

 I have a select statement with a left join that will tell me the rows that
are in system A but not in system B (the target). Question is how to I write
a SQL statement to also insert these rows?

 System information.

 Windows NT4 (System A), Windows server 2003 (System B).
 MySQL 3.23.42-nt running on both systems.

 Paul



-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: [MYSQL] Combine tables from two different systems

2003-10-10 Thread Director General: NEFACOMP 
If you are running version 4.1, you can use a sub-select.
INSERT INTO table2 SELECT table1
WHERE IDs IN (SELECT IDs FROM /* this may be the one with left joins */
table3)


Thanks
Emery
- Original Message -
From: Nobody [EMAIL PROTECTED]
To: PAUL MENARD [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 System B (either manually or write
a
 script).
 Any rows form System A that already have a System B equivalent will be
 silently dropped and only those that do not have an equivalent will be
 written.

 e.g. INSERT IGNORE INTO system_b.table_n (columns)
 SELECT columns FROM system_a.table_n

 HTH
 Rory McKinley
 Nebula Solutions
 082 857 2391
 [EMAIL PROTECTED]
 There are 10 kinds of people in this world,
 those who understand binary and those who don't (Unknown)
 - 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) 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 those rows I want
 to leave the system B data unchanged.
 
  I have a select statement with a left join that will tell me the rows
that
 are in system A but not in system B (the target). Question is how to I
write
 a SQL statement to also insert these rows?
 
  System information.
 
  Windows NT4 (System A), Windows server 2003 (System B).
  MySQL 3.23.42-nt running on both systems.
 
  Paul
 


 --
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]






-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]