[EMAIL PROTECTED] wrote:
(...)
When i try to execute the following query
(...)
i get this error:
ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 6
Current database: test
ERROR 2013 (HY000): Lost connection to MySQL server during query
but if i change my query to this one everything is fine
SELECT
COUNT(DISTINCT field1) as value1,
CONCAT(field2, '') as value2
FROM
table1,
table2
GROUP
BY value2
(here CONCAT(field2, '-') is replaced with CONCAT(field2, '') )
does anyone know what the matter is?
Did you try to make the first query for a second time, when you execute
the second query? It seems that the server abords or closes the
connection meanwhile. Did you waited too long to write/send the query?
Check this for more help http://dev.mysql.com/doc/mysql/en/gone-away.html
Try this query and output the result
SHOW VARIABLES LIKE '%time%';
if you don't find a solution.
--
Nuno Pereira
email: [EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
