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:[EMAIL PROTECTED]>[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>http://lists.mysql.com/mysql
To
unsubscribe:
<http://lists.mysql.com/[EMAIL PROTECTED]>http://lists.mysql.com/[EMAIL PROTECTED]
--
I'm a MySQL DBA in china.
More about me just visit here:
<http://yueliangdao0608.cublog.cn>http://yueliangdao0608.cublog.cn
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
