If you don't want to change any code, you can look into using
federated tables. But if your tables are local, you're adding
unnecessary overhead. You can reference tables in other databases on
the local machine by simply adding the database name before the table
name:
SELECT * FROM database.table
On Jun 19, 2007, at 7:40 AM, Toan. Dang Anh wrote:
Dear All,
I have multi databases with some table is the same structure. I
want to
collect this table to one database and share this table to other
databases, how can I do that? I do not want to change code connect to
database.
Could I link table file to other?=20
Please help me.
I use MySQL 5 on CentOS 4.
Thanks
Toan Dang
==================================
Toan Dang Anh
System Operation Dept.
Email: [EMAIL PROTECTED]
Mobile: 0903 109 699
==================================
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]