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 databas
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
