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 |
How do I truncate all tables in mysql?
Explain triggers and stored procedures?
What causes mysql too many connections?
How to decrement dates by 1 in mysql?
What is sql in mysql?
Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the total number of sold products
Is mysql open source?
How do I start mysql in mysql workbench?
What does mysql flush hosts do?
Do I need to pay for mysql?
How do you create a primary key?
What is delimiter in mysql trigger?
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)