> > 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]