List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:June 18 2002 10:00am
Subject:Re: temporary table
View as plain text  
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:

WE> thx Wilbert

For technical support contracts, goto
This email is sponsored by
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB /

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