From: Dan Nelson
Date: August 3 2003 8:52pm
Subject: Re: Nested SELECT statements problem
List-Archive: http://lists.mysql.com/mysql/146814
Message-Id: <20030803205222.GE38843@dan.emsphone.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

In the last episode (Aug 03), Pascal Dlisle said:
> Finally, I solved my problem by creating a temporary table that holds
> the result of the subquery.  So, it looks like this:
... 
> The only problem I see is when there are concurrent access to the
> table "livreTemp", e.g. when there are multiple simultaneous requests
> of that kind.  Is there a better way for achieving this under mySQL
> 3?

Use the CREATE TEMPORARY TABLE command, which creates tables which are
invisible to other client connections and are automatically dropped
when the client exits.

-- 
	Dan Nelson
	dnelson@stripped