List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:August 28 2011 7:36am
Subject:Re: Arrays
View as plain text  
----- Original Message -----
> From: "Halász Sándor" <hsv@stripped>
> 
> passed in. The table-name will be *sigh* global.

No: when you use /create temporary table/, the table is local to your connection. You can
perfectly open a dozen connections and have them all create a temporary table called
intermediate_results, they'll not interfere with one another. Temporary tables also get
automatically dropped when the connection closes - although it's of course best practice
to do it yourself as soon as you don't need it any longer :-)

Also, do not confuse /create temporary table/ with /create table ... engine=memory/ -
while both are in memory, the latter creates a global table whose metadata (so not the
actual data, just the structure) even survives a reboot.

-- 
Bier met grenadyn
Is als mosterd by den wyn
Sy die't drinkt, is eene kwezel
Hy die't drinkt, is ras een ezel
Thread
Arraysjavad bakhshi24 Aug
  • Re: Arrayshsv26 Aug
    • Re: ArraysJohan De Meersman26 Aug
      • Re: Arraysjavad bakhshi26 Aug
        • Re: ArraysMichael Dykman27 Aug
        • Re: Arrayshsv27 Aug
          • Re: ArraysArthur Fuller27 Aug
            • Re: ArraysJohan De Meersman28 Aug
          • Re: ArraysJohan De Meersman28 Aug
            • Re: Arrayshsv29 Aug
          • Re: ArraysMichael Dykman28 Aug
          • Re: ArraysMySQL)29 Aug
            • Re: Arraysjavad bakhshi2 Sep
              • Re: ArraysMySQL)2 Sep
                • Re: Arraysjavad bakhshi2 Sep
                  • Re: Arrayshsv2 Sep