MYSQL ERROR CODE 2013 PROBLEM
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
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.