Re: mysqlcc temp table created for queries

2006-03-29 Thread Barry
Song Ken Vern-E11804 wrote: It seems like different version are doing things differently. This is the most normal thing in the world! 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

mysqlcc temp table created for queries

2006-03-28 Thread Song Ken Vern-E11804
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 i