Re: How to determine if temporary table exists

2008-11-21 Thread mos
At 12:00 AM 11/21/2008, you wrote: 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

Re: How to determine if temporary table exists

2008-11-20 Thread Dan Nelson
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 doe

Re: How to determine if temporary table exists

2008-11-20 Thread mos
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 co

Re: How to determine if temporary table exists

2008-11-20 Thread Moon's Father
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 a

How to determine if temporary table exists

2008-11-20 Thread mos
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