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.