When a SELECT query is executed does MySQL store the resultset in some table?
If it does, is there a way to find out that table and access it later before the session is closed?


Recommended Answers

All 4 Replies


If you want to save the results of a query in a table have a look at create table select.

you can store it in the session if it is small enough
in a file or another table per d5e5 suggestion

You could create a temporary table and store your query that way. Another way would be to increase your cache and just rerun the query.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.21 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.