List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:June 18 2002 10:00am
Subject:Re: temporary table
View as plain text  
Wilbert,
Tuesday, June 18, 2002, 11:11:38 AM, you wrote:

WE> i have this php script which queries a table. The results are stored in a
WE> temprrary table
WE> "CREATE temporary TABLE t1 SELECT .....statements...";

WE> when I query this table in the same script i can see that the results wore
WE> indeed stored in t1.

WE> however when i call this table from a different script I get the error thet
WE> t1 doesn't exists....

WE> anybody knows why? (mysql 3.23)

It's a particular feature of TEMPORARY tables. TEMPORARY table is
visible only for the connection that created it. Look at:
        http://www.mysql.com/doc/C/R/CREATE_TABLE.html


WE> thx Wilbert




-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Working libmysqld.a for Tru64 5.1?Randall Severy16 Jun
  • Re: Working libmysqld.a for Tru64 5.1?Dan Nelson16 Jun
  • queries within queriesW. Enserink17 Jun
    • RE: queries within queriesNick Arnett17 Jun
  • Re: queries within queriesBhavin Vyas17 Jun
    • Re: queries within queriesTod Harter17 Jun
  • temporary tableWilbert Enserink18 Jun
    • Re: temporary tableVictoria Reznichenko18 Jun
  • Re: temporary tableSammy Lau18 Jun
RE: queries within queriesRobert Casey17 Jun
RE: temporary tableHendrik Schalekamp18 Jun