In the last episode (Nov 20), mos said:
> 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
Why not "CREATE TEMPORARY TABLE IF NOT EXISTS ..."? If you really need
to know whether the table existed before or not, that command will
return a warning if it was there already.