MySQL Forums
Forum List  »  Newbie

create Virtual table during query or load table to memory from text file
Posted by: Scott Critchley
Date: December 11, 2007 11:23AM

I have access to my application database via a secure link, so I cannot link a local database to it, only run queries on the remote server and download the result.

The database is missing some useful information, and I cannot add a table at this stage. I would like to achieve the result by creating a virtual table or the like.

E.g.
Server Database has:
Table PhoneBills
PhoneNr Month PhoneBill
555-111-1111 Jan 50.95
555-111-1111 Feb 54.55
555-111-2222 Jan 150.95
555-111-2222 Feb 154.55

I want to link to my off-line database
Table AddressBook
PhoneNr Name Contract
555-111-1111 John 50.Month
555-111-2222 Bill 200.Month

I.e. so I can get cost by Name.

Note that I do have file write access to the remote server, so I could store AddressBook as a text file on the server without a problem.

So my question is - can I run a cross-tab query against a table I create within the query? (i.e. create virtual view AddressBook as ("555-111-1111", "John", "50.Month", "555-111-2222", "Bill", "200.Month") )

.. or can I load a table into memory only (not saved to the real database) from a text file?

Cheers,
Scott.

Options: ReplyQuote


Subject
Written By
Posted
create Virtual table during query or load table to memory from text file
December 11, 2007 11:23AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.