mysqlcc temp table created for queries - Song Ken Vern-E11804 - com.mysql.lists.mysql

2 messages in com.mysql.lists.mysqlmysqlcc temp table created for queries

From	Sent On	Attachments
Song Ken Vern-E11804	28 Mar 2006 17:45
Barry	29 Mar 2006 01:48

Subject:	mysqlcc temp table created for queries
From:	Song Ken Vern-E11804 (kens...@motorola.com)
Date:	03/28/2006 05:45:20 PM
List:	com.mysql.lists.mysql

Hi,

I am using mysqlcc 0.9.4-beta to browse my DB. Server side am using 5.0.18-nt.

However, when I try to double click on a table to see the data, it will always return the error. "[localhost] ERROR 1146: Table 'test.1' doesn't exist" The SQL query for this is "SELECT * FROM `test`" The query is still sucessful but I would like to know what causes this error.

However, when I try to browse another server running 4.1.10-nt, double clicking produces no such error. Setup is similiar to the above.

It seems like different version are doing things differently.

Looking through the newsgroups & forums, I understand that that mysql5.0 will prepend the tablename to each column.

But I don't understand what does 'test.1' refer to.

Can anyone help explain?

Thank you.