List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:August 3 2003 8:52pm
Subject:Re: Nested SELECT statements problem
View as plain text  
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
Thread
Nested SELECT statements problemPascal Délisle3 Aug
  • Re: Nested SELECT statements problemDan Nelson3 Aug
    • Re: Nested SELECT statements problemInc Eternal Designs3 Aug
  • RE: Nested SELECT statements problemLin Yu3 Aug
    • Re: Nested SELECT statements problemPascal Délisle3 Aug
      • Re: Nested SELECT statements problemPascal Délisle3 Aug
        • Re: Nested SELECT statements problemJim McAtee3 Aug
          • Re: Nested SELECT statements problemPascal Délisle3 Aug
        • Re: Nested SELECT statements problemMatthew McNicol3 Aug
        • Re: Nested SELECT statements problemDan Nelson3 Aug
  • Re: Nested SELECT statements problemAdam Fortuno4 Aug