Topic: Sync one table with an other (alias-Table)

[mylo]

Hello,

my problem is, that i have a foreign mysql database which can't be changed. It contains some tables. What i want to do is to create a small subset of this database and use the values of it in my own, cleaner, table structure. My problem is, how to do this?
Should i use views, or triggers or what?
I don't want do change the content, only the fieldnames and the amount of them.

[Mchl]

Read on FEDERATED storage engine

[mylo]

Hm, maybe i get something wrong, but doc says:

"The structure of this table must be exactly the same as that of the remote table..."

which, in my case, is not the task. I need to be other than the source table.

[Mchl]

I suppose, you would need to make a link to the remote table using FEDERATED engine, and then create a view, that would select those columns, that you need.

I am not really sure, never done something like that.

[mylo]

To clarify things, i need to "mix" fields from an existing table with "translated" fieldnames into a table with my own fields.
Both tables reside on the same mysql server.