MySQL Forums
Forum List  »  Newbie

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

At the moment I am downloading the results of the usage query and cross-referecing the numbers to names in XL (Vlookup), I was hoping to store the AddressBook on the server then run a query once and get my result.

Any links to a tutorial on loading a table in to MEMORY?

For a Cross-Tab query, I was thinking of something simple such as:

Select AddressBook.Name, PhoneBill.Month, PhoneBill.BillAmount from AddressBook, PhoneBill where AddressBook.PhoneNumber = PhoneBill.PhoneNumber order by Name, Month;

I have similar (and 4, 5, 6 table linked queires) running with the existing tables.

Options: ReplyQuote


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


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.