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 the
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
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
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
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