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 language is used in mysql?
Explain the storage engines in mysql?
How do I uninstall mysql connector?
How do I show columns in mysql?
What are the other commands to know the structure of table using MySQL commands except explain command?
what is the querry for all managers salary?
What is mysql default port number?
What causes mysql too many connections?
Fname Lname City Pin ramesh kumar salem 365241 Query to generate a code having the firstletter of Fname,Lname & 3letter of city Last 3letter of pin,all in capital letters
Is mysqli faster than mysql?
What is mysql protocol?
What does myisamchk do?