I, too, have been unable to get temporary tables to work from MYsql-FRONT. They work every other way I try them (command line, delphi zeos component, etc).
----- Original Message ----- From: "Ruda Gossen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, July 06, 2002 10:18 AM Subject: Re: Re: Re: Re: Temporary Table > Thanks Egor, but the table names in the example are > already lower case and I pasted them in SQL window of > the client. > > Since yesterday I have test to type the script > manually at the prompt in a DOS-window and then all > worked well. > > Trying to do the same in the SQL-window of MySQL-Front > all was OK until I typed the statement: > > select shop.article, dealer, shop.price > from shop, tmp > where shop.article=tmp.article and > shop.price=tmp.price; > > Now I got an alert-box which tells me: > > Table 'mybase.tmp' does'nt exist. > > Finally, it was no problem to: > > drop table tmp; > > Seems that the problem depends on MySQL-Front. > > Best regards > > Alf > > --- Egor Egorov <[EMAIL PROTECTED]> skrev: > > > If so, you should wrote table name in lower case > > (tmp instead of TMP), > > because in the manual table name in lower case. > > > > Look at: > > > > mysql> SELECT * FROM TMP; > > ERROR 1146: Table 'database_name.TMP' doesn't exist > > mysql> SELECT * FROM tmp; > > +---------+-------+ > > | article | price | > > +---------+-------+ > > | 0001 | 3.99 | > > | 0002 | 10.99 | > > | 0003 | 1.69 | > > | 0004 | 19.95 | > > +---------+-------+ > > 4 rows in set (0.00 sec) > > > > > > > > > > > > -- > > 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 > > --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.365 / Virus Database: 202 - Release Date: 24/5/2002 --------------------------------------------------------------------- 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
