468,133 Members | 1,236 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,133 developers. It's quick & easy.

show TEMPORARY tables ???

Hi there,

Is there a way to list the TEMPORATY tables?
I have tried SHOW TABLES, but this command only list the regular tables.

Thank you very much for your answer.

Regards,
Stefan.
Jun 3 '06 #1
1 25259
"Stefan van Roosmalen" <ro******@planet.nl> wrote in message
news:44**********************@text.nova.planet.nl. ..
Hi there,

Is there a way to list the TEMPORATY tables?
I have tried SHOW TABLES, but this command only list the regular tables.

Thank you very much for your answer.


No. MySQL will not SHOW you tables created with the TEMPORARY keyword.

Note that there is no reason why you can't create ordinary tables instead
and then use them temporarily by DROPing them when you are finished.

I make extensive use of small TEMPORARY tables in automated scripts. While
I am developing these scripts, I leave out the TEMPORARY keyword so that I
can examine these tables an debug using the normal MySQL facilities. When I
am satisfied that my scripts are functioning as advertised, I then add the
TEMPORARY keyword back to my CREATE TABLE statements. When used properly,
TEMPORARY tables can speed up certain processes dramatically. But when you
need to actually see what is going on, you will have to leave the TEMPORARY
out.

Thomas Bartkus
Jun 5 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Zlatko Matić | last post: by
1 post views Thread by gcdp | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.