AFAIK, temporary table is session based. i.e. only the session creating
the temporary table can manipulate the table.
Wilbert Enserink wrote:
>
> hi all,
>
> i have this php script which queries a table. The results are stored in a
> temprrary table
> "CREATE temporary TABLE t1 SELECT .....statements...";
>
> when I query this table in the same script i can see that the results wore
> indeed stored in t1.
>
> however when i call this table from a different script I get the error thet
> t1 doesn't exists....
>
> anybody knows why? (mysql 3.23)
>
> thx Wilbert
>
> -------------------------
> Pas de Deux
> Van Mierisstraat 25
> 2526 NM Den Haag
> tel 070 4450855
> fax 070 4450852
> http://www.pdd.nl
> info@stripped
> -------------------------
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <mysql-thread112299@stripped>
> To unsubscribe, e-mail
> <mysql-unsubscribe-sammy=team.outblaze.com@stripped>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
--
Sammy Lau
mailto: sammy@stripped
- Tell me what you want and I'll tell you how you can live without it.
