1

Topic: Temporary tables

Kind time of days, children!
Created the temporary table:

CREATE TEMPORARY TABLE pogoda1
SELECT pogoda.id_punkt, pogoda.t_day
FROM pogoda;

It formed, and responds on:

SELECT * FROM pogoda1;

All did it in WorkBench.
Here if we can display it, means somewhere there was an object of the given table and it somewhere should be displayed, so after all?
I cannot find it.
Prompt where in WorkBench it should be displayed?

2

Re: Temporary tables

What for? To whom is the temporary table which dies together with connection necessary?

3

Re: Temporary tables

Akina, for example if I want by data from given temporary table to construct other request

4

Re: Temporary tables

Vlad __ i __ mir wrote:

I want by data from given temporary table to construct other request

And that then is

Vlad __ i __ mir wrote:

It formed, and responds on:

SELECT * FROM pogoda1;

as not other request?