009 22:10
To: Weston, Craig (OFT)
Cc: MySQL General List
Subject: Re: Merging Databases
We don't want to use a view because then this database will not
be consistent with the others.
We can't simply use a select from .. insert into because when we
renumber
table1's ID column, items in
On 11-May-09, at 2:09 PM, Johnny Withers wrote:
We don't want to use a view because then this database will not
be consistent with the others.
We can't simply use a select from .. insert into because when we
renumber
table1's ID column, items in table2 and 3 and so on may link to the ID
colu
We don't want to use a view because then this database will not
be consistent with the others.
We can't simply use a select from .. insert into because when we renumber
table1's ID column, items in table2 and 3 and so on may link to the ID
column in that table. So we need to update the ID column in
-Original Message-
From: Johnny Withers [mailto:joh...@pixelated.net]
Sent: Monday, May 11, 2009 3:30 PM
To: MySQL General List
Subject: Merging Databases
Hi,
I have a lot of databases that have the exact same tables and each table has
the exact same column structure. I'm looking at merg
If all tables name are unique, and if you can bear the downtime, just shut
down the server and copy the files of one of the database to another
database will do
- Original Message -
From: "Andrew Dennison" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, February 01, 2001 11:21
