From: Date: July 5 2002 6:55pm Subject: Re: Re: Re: Temporary Table List-Archive: http://lists.mysql.com/mysql/113879 Message-Id: <20020705165551.54512.qmail@web20418.mail.yahoo.com> MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Forgive me the wrong addressing - I didn't observed that. Yes I used same connection all the time. I am a SQL-newbee and I suspect that the problem is the installation or configuration. I use Windows 2000 Pro, MySQL 4.0.1-alpha-max-nt and MySQL-Front 2.2 The MySQL-server and the client are installed on the same computer. I used copy&paste from the example-site to the SQL-window of MySQL-Front. Regards Alf --- Egor Egorov skrev: > 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 > > > > --------------------------------------------------------------------- > 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 > > To unsubscribe, e-mail > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > ===== _____________________________________________________ Följ VM på nära håll på Yahoo!s officielle VM-sajt www.yahoo.se/vm2002 Håll dig ajour med nyheter och resultat, med vinnare och förlorare...