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 <[EMAIL PROTECTED]> 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 > / /|_/ / // /\ \/ /_/ / /__ > [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ 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 > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > 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... --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php