Hi,
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?
thanks,
Hi,
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?
thanks,
Jump to PostNo.
No.
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.
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.