Re: Re: Re: Temporary Table

[Egor Egorov]

Hello Ruda,
Friday, July 05, 2002, 4:05:03 PM, you wrote:

Please, send your questions in the maling list, not only me.

RG> Hello Egor,
RG> I get NO result when i run the whole code.
RG> If I run the create-statement once more I was told
RG> that the table already exists and that is not a
RG> surprise but when I run
RG> SELECT * FROM TMP 
 
RG> I was told that the table doesn't exist in the active
RG> database.

Did you retrieve data with SELECT * FROM TMP statement in the same
connection to the MySQL server or in another?

Temporary table are created per connection.

RG> Do You have an example which work for you?

Example in the manual works for me...






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