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 index length in mysql?
What is mysql architecture?
What are the functions of commit and rollback statements?
What is MySQL Stored Procedure?
Query to select passwords from a table having a column "Password" Whose length is b/w 8 &15 and having 'A' as the first character in the password irrespective of case.
What is username in mysql?
What is a trigger? How you can create a trigger in mysql?
What does it mean to be case sensitive?
How do I copy an entire mysql database?
Which is faster mongodb or mysql?
How to execute mysql query in php?
Explain Normalization concept?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)