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 is difference between mysql_connect and mysql_pconnect?
What are the different column comparison operators in mysql?
Is mysql still relevant?
how we can use more then one primary key in Single Table
What is mysql database used for?
Where is the mysql data directory?
What are queries used for?
How do I know if mysql is running on windows?
What is a join? Explain the different types of mysql joins.
What is mysql cursor?
Why do we use pragma autonomous transaction?
Can I use mysql for free?