show TEMPORARY tables ???

Stefan van Roosmalen

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

Subscribe Post Reply

26780

Thomas Bartkus

"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

by: Soefara | last post by:

Dear Sirs, I have been developing an application on Windows with MySQL 3.23, making use of temporary tables. Now when I try to port the application to a Unix box running also MySQL 3.23, I...

MySQL Database

Drop temporary tables whilst connected ?

by: Ryan | last post by:

Just a quicky about temporarary tables. If using QA, when you create a temporary table, it gets dropped if you close the query. Otherwise you need to state 'DROP TABLE myTable' so that you can...

Microsoft SQL Server

Creating a common table expression--temporary table--using TSQL???

by: randi_clausen | last post by:

Using SQL against a DB2 table the 'with' key word is used to dynamically create a temporary table with an SQL statement that is retained for the duration of that SQL statement. What is the...

Microsoft SQL Server

How to find indexes working on a temporary table in UDB AIX.(UDB 8.1)

by: Sampath Reddy | last post by:

Hi Everybody, We are using UDB v8.1 I will explain about my Stored procedures which we are executing in UDB AIX box. We have 3 millions(apporox) of data in 22 tables. By applying the business...

DB2 Database

Stored procedures using declared temporary tables: please help!

by: Keith Watson | last post by:

Hi, we are currently implementing an application running on DB2 V7 on Z/OS using largely COBOL stored procedures, managed using WLM. Some of these stored procedures declared global temporary...

DB2 Database

Does anyone have experience with the efficiency of global temporary tables?

by: Chuck Crews | last post by:

I am interested in declaring a global temporary table within an application. The application processes 1 set of 600 or less rows each iteration. Multiple programs can and do call this one...

DB2 Database

Temporary Tables. Where will they be created

by: Mike Ridley | last post by:

I have 2 databases called (for example) "progs.mdb" and "files.mdb". Both these databases reside on computer "myserver". The progs database has links to the tables in the files database....

Microsoft Access / VBA

postgreSQL temporary tables and MS Access

by: Zlatko Matiæ | last post by:

I tried to work with postgres temporary tables from MS Access, but unsuccessfully... I was able to create temporary table by pass-through query, also I succeeded in creating linked table through...

Microsoft Access / VBA

How to find query plan for a stored procedure using temporary tables

by: comp_databases_ms-sqlserver | last post by:

This post is related to SQL server 2000 and SQL Server 2005 all editions. Many of my stored procedures create temporary tables in the code. I want to find a way to find the query plan for these...

Microsoft SQL Server

Navigating the Data Structures and Algorithms (DSA)

by: BarryA | last post by:

What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...

Algorithms / Advanced Math

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

Similar topics