what are Federated tables?

hi,

can any one explain, what is the purpose of Federated tables?

Mr.Prabeen,

When you create a table using one of the standard storage engines (such as MyISAM, CSV or InnoDB), the table consists of the table definition and the associated data. When you create a FEDERATED table, the table definition is the same, but the physical storage of the data is handled on a remote server.