时间戳

首页 > 解决方案 > 在查询“错误代码：2013”​​期间失去与 MySQL v8 服务器的连接。

mysql - 在查询“错误代码：2013”​​期间失去与 MySQL v8 服务器的连接。

问题描述

我需要你的帮助。当我如下所述运行查询时，我得到 MySQL“错误 2013：丢失连接”。我使用服务器 v8。

SELECT CONCAT(UCASE(LEFT(tblpatients.Lname,1)), LCASE(SUBSTRING(tblpatients.Lname,2))) as lname, CONCAT(UCASE(LEFT(tblpatients.mi,1)), LCASE(SUBSTRING(tblpatients.mi,2))) as mi, 
CONCAT(UCASE(LEFT(tblpatients.fname,1)), LCASE(SUBSTRING(tblpatients.fname,2))) as fname, tblpatients.PhoneNum as PhoneNum, 
DATE_FORMAT(tblpatients.Bday,'%m/%d/%Y')as Bday, TIMESTAMPDIFF(YEAR, Bday,CURDATE()) AS pxage, 
tblpatients.PatientID as PatientID, DATE_FORMAT(tblobgyne.obgyneDate,'%m/%d/%Y') as obgyneDate, TIME_FORMAT(tblobgyne.obgyneTime, '%h:%i%p') as obgyneTime, 
tblparity.ParityID, tblobgyne.OBGyneID, tblobgyne.chiefcomplain, tblobgyne.companyname as companyname, 
CONCAT(UCASE(LEFT(tblparity.pxservice,1)), LCASE(SUBSTRING(tblparity.pxservice,2))) as pxservice

FROM tblpatients
JOIN tblparity ON tblpatients.PatientID = tblparity.PatientID
JOIN tblobgyne ON tblparity.ParityID = tblobgyne.ParityID                                               
WHERE obgyneDate >= 03-20-2019 ORDER BY obgyneTime ASC;

标签： mysqlmysql-workbenchmysql-error-2013

解决方案

推荐阅读