thread where it's been created, and
vanishes when the connection closes.
PB
-
Gregory Machin wrote:
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.
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
ow can I see the temp tables ?
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 ve
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!
&g
> -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
>
Hi.
I have just found out that my hosting provider is using mysql 4 and I'm
using mysql 5 the one query I need wont work and is a key feature in the
application .. here is the query i'm using
SELECT dealer_id, auto_id, bid_amount FROM bids b1 WHERE bid_amount=(SELECT
MAX(b2.bid_amount)
FROM bids
