What is federated tables in mysql?



What is federated tables in mysql?..

Answer / Shikha Shukla

Federated tables are virtual tables in MySQL that allow you to treat tables located in other databases or servers as if they were local. Federated tables do not store data but only provide an interface for querying remote tables.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More MySQL Interview Questions

How do I install and use mysql?

1 Answers  


How do I create a new database in mysql?

1 Answers  


Use mysqldump to create a copy of the database?

2 Answers  


What is mysql uuid?

1 Answers  


How set mysql root password?

1 Answers  


What are the different data types in mysql?

1 Answers  


How do you create a table in mysql workbench?

1 Answers  


Explain % and _ inside like statement?

1 Answers  


I want to make a query where I want to eliminate the duplicate rows from the table. For example : Input : Table : NAME Column1 Column2 India USA USA India UK India India UK The desired output that I want to eliminate the duplicates Output India USA UK India Thanks

2 Answers   Sun Life,


What is definer in mysql trigger?

1 Answers  


What is the use of mysql_fetch_array () function in php?

1 Answers  


How do I view tables in mysql workbench?

1 Answers  


Categories