Explain federated tables?

Answers were Sorted based on User's Feedback



Explain federated tables?..

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

Explain federated tables?..

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

Explain federated tables?..

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

Post New Answer

More MySQL Interview Questions

What are the drivers in MySQL?

1 Answers  


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?

0 Answers  


How to delete a trigger in mysql?

0 Answers  


Can you tell how many values can set the function of mysql to consider?

0 Answers  






How can I see all mysql databases?

0 Answers  


What is pdo :: fetch_assoc?

0 Answers  


What is the query to display top 20 rows?

0 Answers  


Where’s database data actually stored? Is there a way to see the files which are stored?

0 Answers  


How to display odd rows in student table in mysql?

0 Answers  


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

0 Answers  


How set mysql root password?

0 Answers  


Categories