Gregory
>I thought about that but I'm worried about the users getting the rite data
>if multiple users make the same requests at the same time ... i supose the
>easiest would be to name the temp tables after the user making the request
>??
A temp table is visible only in the thread where it's be
You don't need to drop a TEMPORARY table... it is dropped at
connection-close !
You don't need to wory about different names for TEMPORARY tables...
Manual says:
> A TEMPORARY table is visible only to the current connection, and is
> dropped automatically when the connection is closed. This mean
It's working ok ..
But I have one problem ..
I'm getting the following error "Table 'max_bids3' already exists";
but I get the following ...
mysql> DROP TABLE max_bids3;
ERROR 1051 (42S02): Unknown table 'max_bids3'
What do I do to fix this, and how can I see the temp tables ?
On 3/21/06, Addis
On 3/21/06, Addison, Mark <[EMAIL PROTECTED]> wrote:
>
> > -Original Message-
> > From: Gregory Machin [mailto:[EMAIL PROTECTED]
> > Sent: 21 March 2006 11:28
> > To: mysql@lists.mysql.com
> > Subject: mysql query and version problem Help!
> >
> > Hi.
> >
> > I have just found out that
> -Original Message-
> From: Gregory Machin [mailto:[EMAIL PROTECTED]
> Sent: 21 March 2006 11:28
> To: mysql@lists.mysql.com
> Subject: mysql query and version problem Help!
>
> Hi.
>
> I have just found out that my hosting provider is using mysql
> 4 and I'm
> using mysql 5 the o
