At 08:02 PM 11/20/2008, you wrote:
>Try drop table if exists Tablex;
Ahhh, I don't necessarily want to drop the table if it already exists. :)
If the table already exists then I'll add new rows to it (and keep the
existing rows). If the table doesn't exist, then I'll create it.
I suppose could count the rows in Tablex and it would throw an exception if
the table did not exist . But I really didn't want to resort to trapping an
exception in my program. I thought there should be an easy way using SQL to
determine if a temporary table exists or not.
Mike
>On Fri, Nov 21, 2008 at 9:53 AM, mos
><<mailto:mos99@stripped>mos99@stripped> 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>http://lists.mysql.com/mysql
>>To
>>unsubscribe:
>><http://lists.mysql.com/mysql?unsub=1
>
>
>
>--
>I'm a MySQL DBA in china.
>More about me just visit here:
><http://yueliangdao0608.cublog.cn>http://yueliangdao0608.cublog.cn
