With MySQL, you can join tables that are in different databases as long as they are on the same server. In your case, you could run: SELECT s.name FROM A.bouncebacks b, subcriber s where s.email = b.email
Regards, Joseph Bueno
Brandl, Thomas wrote:
The thing is that this particular table in database 'A' contains
bounceback email addresses, all other databases are customer databases
containing pretty large subscriber tables. Now I need to find matches
between this bounceback table and all other customer subscriber tables.
So I'd like to do a join over these, which is not possible because they
reside in different databases (Like SELECT s.name FROM bouncebacks b, subcriber s where s.email =
b.email).
So if I could replicate this table, I could perform the above join.
right now I find matches between the bounceback and the subscriber list
by scripting, which is slooooooow - with ca. 10,000 bouncebacks and say
up to 15,000 subscribers/customer.
I don't really like this concept, but I can't think of a better one...
Thanks again for suggestions!
Tom
-----Ursprüngliche Nachricht----- Von: Paul DuBois [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 14. März 2003 19:19 An: Brandl, Thomas; [EMAIL PROTECTED] Betreff: Re: replication on single server
At 10:49 +0100 3/14/03, Brandl, Thomas wrote:
> Hey everybody,
I want to replicate several tables from one database to all other
databases on the same machine, so to say a table-level-replication
Simply said, imagine this scenario:
A MySQL server with about 10 databases: A and 1 to 9.
Database A contains a 'special' table that is supposed to be
replicated to all other databases on the same machine, so
it is kinda
like the master database. The table has the same name on every database. Is such a thing possible and if yes, how?
Thanks very much for your help!
> Thomas
I don't understand why you'd bother. Put it in one database and grant everybody permission to access it. Wouldn't that accomplish the same thing, without all the headache of trying to copy it everywhere?
-- Paul DuBois, [EMAIL PROTECTED] http://www.kitebird.com/ sql, query
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
