Can you create a merge table whose component tables exist in other
databases? I am able to create merge tables for tables that are in one
database but I want to be able to aggregate data from multiple
databases. I am using 3.23 but I am migrating to 4.0.5a next week, if
that makes a difference. The following is an example of what I am
trying to do:
Database Name: cust1
Table Name: logs
Database Name: cust2
Table Name: logs
Database Name: all
CREATE TABLE all.combined_logs ("column defs here")
TYPE=MERGE UNION=(cust1.logs, cust2.logs) INSERT_METHOD=NO;
Thanks
Lou
Query, sql --> to defeat the spam filter....
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
