Explain federated tables?
Answers were Sorted based on User's Feedback
Answer / amith
Introduced in MySQL 5.0, federated tables allow access to
the tables located on other databases on other servers.
Is This Answer Correct ? | 9 Yes | 0 No |
Answer / sivaraj
The FEDERATED storage engine is available beginning with
MySQL 5.0.3. It is a storage engine that accesses data in
tables of remote databases rather than in local tables.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / aravind
The FEDERATED storage engine is available beginning with
MySQL 5.0.3. This storage engine enables data to be
accessed from a remote MySQL database on a local server
without using replication or cluster technology. When using
a FEDERATED table, queries on the local server are
automatically executed on the remote (federated) tables. No
data is stored on the local tables
Is This Answer Correct ? | 5 Yes | 0 No |
What are the drivers in MySQL?
How can increase the performance of MySQL select query?
3 Answers RV Technologies, Span Systems,
I want to start and stop mysql on windows? How do I do that?
How to delete a trigger in mysql?
Can you tell how many values can set the function of mysql to consider?
How can I see all mysql databases?
What is pdo :: fetch_assoc?
What is the query to display top 20 rows?
Where’s database data actually stored? Is there a way to see the files which are stored?
How to display odd rows in student table in mysql?
table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases
How set mysql root password?