Re: Re: Re: Re: Temporary Table

[Ruda Gossen]

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...