MySQL Forums
Forum List  »  General

MYSQL ERROR CODE 2013 PROBLEM
Posted by: Howard Krawitz
Date: June 10, 2012 10:08PM

Here is the code I am using. This used to work but now just keep giving me the error

select canspecial.postcode, count(canspecial.postcode)
from canada.canspecial
inner join canada.canpc
on canpc.postcode = canspecial.postcode
where dob ='0000-00-00'
group by postcode
Error Code: 2013. Lost connection to MySQL server during query 600.495 sec

FYI Canspecial is 1.3 million records and canpc is about 113000 records. We are matching postcodes,(in the US they are called zip codes). Both files are small. I used to run this without a where clause as well, but nether the one above or one without the where clause doesn't work

I am using Workbench 5.2.36 ce
mysql: 5.5

I need help. Please advise me by email: howard@globalvillagemktg.com or phone 307-200-4117.

Thanks

Howard

Options: ReplyQuote


Subject
Written By
Posted
MYSQL ERROR CODE 2013 PROBLEM
June 10, 2012 10:08PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.