Copy from MySQL Server to VirtualTable

Copy from MySQL Server to VirtualTable

Postby jan.mrazek » Mon 14 Aug 2006 13:59

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 :shock:
Posts: 1
Joined: Mon 14 Aug 2006 13:22

Postby Antaeus » Thu 31 Aug 2006 09:11

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.
Posts: 2098
Joined: Tue 14 Feb 2006 10:14

Return to VirtualDAC