MySQL Forums :: General :: MYSQL ERROR CODE 2013 PROBLEM

Advanced Search

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: or phone 307-200-4117.



Options: ReplyQuote

Subject Written By Posted
MYSQL ERROR CODE 2013 PROBLEM Howard Krawitz 06/10/2012 10:08PM
Re: MYSQL ERROR CODE 2013 PROBLEM Rick James 06/12/2012 05:38PM

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.