Member Avatar for alenD

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,

  • 5 Contributors
  • 4 Replies
  • 103 Views
  • 5 Days Discussion Span
  • Latest Post Latest Post by b89smith
Member Avatar for debasisdas

No.

Member Avatar for d5e5

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

Member Avatar for almostbob

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

Member Avatar for b89smith

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.