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