Re: Re: Re: Re: Temporary Table

[Egor Egorov]

Ruda,
Friday, July 05, 2002, 7:55:51 PM, you wrote:

RG> Forgive me the wrong addressing - I didn't observed
RG> that.

RG> Yes I used same connection all the time. I am a
RG> SQL-newbee and I suspect that the problem is the
RG> installation or configuration.

RG> I use Windows 2000 Pro, MySQL 4.0.1-alpha-max-nt and
RG> MySQL-Front 2.2

RG> The MySQL-server and the client are installed on the
RG> same computer.

RG> I used copy&paste from the example-site to the
RG> SQL-window of MySQL-Front.

Check your my.cnf file is there entry
set-variable=lower_case_table_names= 0
?
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