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" <ruda66@stripped>
To: <mysql@stripped>
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 <egor.egorov@stripped> 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
> > / /|_/ / // /\ \/ /_/ / /__
> > 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
> > <mysql-thread113915@stripped>
> > To unsubscribe, e-mail
> > <mysql-unsubscribe-ruda66=yahoo.se@stripped>
> > 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 <mysql-thread113920@stripped>
> To unsubscribe, e-mail
<mysql-unsubscribe-yoder=pesqueira.com.br@stripped>
> 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
