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?



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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.