Copy from MySQL Server to VirtualTable

[jan.mrazek]

Hello,
please, can you tell me, if it is possible to copy whole table from MySQLServer unless delete the structure of the table?
I make a SELECT statment, then I add a column, that´s OK. But how can I update the fields e.g. every minute? If I make SELECT statment, the added column delets from the virtual table, but I want it to be there.

Can you tell me how to do it, or any other solution of this problem?

Thank You,
Jan Mrazek

[Antaeus]

To prevent structure deletion of VirtualTable you should manually clear data from VirtualTable and copy records from MSTable field by field, record by record in a double cycle.