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)
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
I need help. Please advise me by email: firstname.lastname@example.org
or phone 307-200-4117.