Do you have a question? Post it now! No Registration Necessary. Now with pictures!
- Stefan van Roosmalen
June 3, 2006, 11:29 pm
rate this thread
Re: show TEMPORARY tables ???
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
- » How do I pull info from one database to save in a session to push to a different DB
- — Previous thread in » MySQL Database Forum
- » Americanas.com SALDO de TVs Com at 80% de Desconto (29798)
- — Newest thread in » MySQL Database Forum