, 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 my hosting provider is using mysql
4
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 means
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.com
Subject: mysql query and version
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
-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 one query I
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 my hosting provider