> > I know I can issue "show tables" to give me a list of 
> tables from the 
> > current database, how can I do the same thing with 
> temporary tables? 
> > That is, is there a command to list the current temporary tables?
> 
> You can't.

RATS!!!

Jeff

> -----Original Message-----
> From: Egor Egorov [mailto:[EMAIL PROTECTED] 
> Sent: Thursday, October 23, 2003 4:38 AM
> To: [EMAIL PROTECTED]
> Subject: Re: Detect temporary tables
> 
> 
> "Jeff McKeon" <[EMAIL PROTECTED]> wrote:
> > I know I can issue "show tables" to give me a list of 
> tables from the 
> > current database, how can I do the same thing with 
> temporary tables? 
> > That is, is there a command to list the current temporary tables?
> 
> You can't.
> 
> 
> 
> -- 
> For technical support contracts, goto 
> https://order.mysql.com/?ref=ensita
> This email is sponsored 
> by Ensita.net http://www.ensita.net/
>    __  ___     ___ ____  __
>   /  |/  /_ __/ __/ __ \/ /    Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
>        <___/   www.mysql.com
> 
> 
> 
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    
> http://lists.mysql.com/mysql?> [EMAIL PROTECTED]
> 
> 

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to