Try drop table if exists Tablex; On Fri, Nov 21, 2008 at 9:53 AM, mos <[EMAIL PROTECTED]> wrote:
> How can I determine if a temporary table exists? Normally I use something > like: > > create temporary table Tablex like Table1; > show tables like "Tablex"; > > but the Show Tables never displays any rows for a temporary table even > though the temporary Tablex exists. (All in same thread). > > So is there a better way to determine if a temporary table exists? > TIA > Mike > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- I'm a MySQL DBA in china. More about me just visit here: http://yueliangdao0608.cublog.cn