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 / /|_/ / // /\ \/ /_/ / /__ [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
