Displaying Temporary Tables

[jordanpope]

Does anyone know how to display temporary tables? I've noticed a fairly large .MYD file (and corresponding .frm and .MYI) files in the folder of one of my databases. The filename starts as #sql-, which I understand is the naming structure for temporary tables. I would like to delete the file, but obviously don't want to cause any damage to the database. Is this just some sort of cache from past temporary tables? How can I view any current temporary tables?

Thanks

 

[QatQat]

A database is not like a word document's file.
It does not create a temporary file when accessed neither it caches your operations.
Temporary tables are created with specific syntax, therefore if you find them it means that someone has created them and not yet deleted.

To display the content of a temporary table you query the table like a normal one.


select ...... from temporary_table_name

Bye


Qatqat


Life is what happens when you are making other plans.

 

[jordanpope]

Returning to my question - "How can I view any current temporary tables" - not how can I view the content of temporary tables. Since temporary tables aren't displayed using the SHOW TABLES command, how can display existing temporary tables.