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]
Re: [MYSQL] Combine tables from two different systems
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]
[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