RE: show temporary table

2005-01-23 Thread Clint Edwards 
Sam,
You can use 'show tables' with a like clause if you prefix your temporary 
tables with a string such as 'tmp_'.  See the manual for syntax:

http://dev.mysql.com/doc/mysql/en/show-tables.html
Clint
From: sam wun <[EMAIL PROTECTED]>
To: mysql@lists.mysql.com
Subject: show temporary table
Date: Sun, 23 Jan 2005 15:47:22 +0800
Hi,
How can I see all temporary tables that created by Create Temporary Table 
command in mysql 5.01?

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

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

show temporary table

2005-01-22 Thread sam wun 
Hi,
How can I see all temporary tables that created by Create Temporary 
Table command in mysql 5.01?

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