From: Johan De Meersman Date: August 28 2011 7:36am Subject: Re: Arrays List-Archive: http://lists.mysql.com/mysql/225607 Message-Id: <1034a86e-8391-40dc-8aa3-e54b40b90ff6@zimbra> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable ----- Original Message ----- > From: "Hal=C3=A1sz S=C3=A1ndor" > > passed in. The table-name will be *sigh* global. No: when you use /create temporary table/, the table is local to your conne= ction. You can perfectly open a dozen connections and have them all create = a temporary table called intermediate_results, they'll not interfere with o= ne another. Temporary tables also get automatically dropped when the connec= tion closes - although it's of course best practice to do it yourself as so= on as you don't need it any longer :-) Also, do not confuse /create temporary table/ with /create table ... engine= =3Dmemory/ - while both are in memory, the latter creates a global table wh= ose metadata (so not the actual data, just the structure) even survives a r= eboot. -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel