select * from database1..tablename union all select * from database2..tablename union all select * from database3..tablename
select * from servername1.db1.user1.tb union all select * from servername2.db2.user2.tb union all select * from servername3.db3.user3.tbselect * from ( select * from servername1.db1.user1.tb union all select * from servername2.db2.user2.tb union all select * from servername3.db3.user3.tb ) t where ...........
union all
select * from database2..tablename
union all
select * from database3..tablename
union all
select * from servername2.db2.user2.tb
union all
select * from servername3.db3.user3.tbselect * from
(
select * from servername1.db1.user1.tb
union all
select * from servername2.db2.user2.tb
union all
select * from servername3.db3.user3.tb
) t
where ...........
新建一个数据库,在这三个数据库中写存储过程或触发器,定时(或其它方法)把三个数据库中的数据复制到新数据库中?能实现吗?多谢!