Interested to Buy Any Domain ? << Click Here >> for more details...
Explain federated tables?
- 3 Answers
- 9127 Views
- Tech Mahindra, I also Faced
- E-Mail Answers
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 |
How do you select a table?
How do I start mysql client?
How to represent ENUMs and SETs internally?
What storage engines are used in MySQL?
How can we run batch mode in mysql?
What are the types of queries?
How do you change a password for an existing user via mysqladmin?
What is difference between mysql and mysql server?
What are the advantages of mysql in comparison to oracle?
Why do we use the mysql database server?
Give the syntax of GRANT commands?
What is the function of mysqldump?
-
Oracle (3259) - 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)
