----- Original Message ----- > From: "Halász Sándor" <h...@tbbs.net> > > 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org