MySQL Forums
Forum List  »  Newbie

Re: create Virtual table during query or load table to memory from text file
Posted by: Anthony Willard
Date: December 11, 2007 11:32AM

You could create a temporary-like table using the MEMORY storage engine, then load your data into that. This assumes you have enough memory to actually contain the entire contents of your input data file.

Once you have your file/table loaded, you can run queries against it. However, there is no cross-tab functionality in MySQL. But, you could create a data set that you could export to another tool to massage the data as you need.

Maybe you should try to download the remote data and use it locally, where you can have more features and tools at your disposal.

Options: ReplyQuote


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


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.