mysql查詢中很怪異的問題

lrq3

問題描述:
1.MySql版本:4.1.8
2.用Sql查詢,拋出以下問題:   
  
   ERROR 2013 (HY000): Lost connection to MySQL server during query

3.如果去掉Sql語句中的 limit 項 或者去掉 order by 或者去掉一個表關(guān)聯(lián) 或者去掉一部分查詢的字段,該語句都能正常運行

4.Sql語句如下所示:
    select MoniRecord.moreNo,MoniRecord.moreEndType,ProvinceInfo.prinName,MoniRecord.moreAreaCity,MoniRecord.moreOpenSpeed,MoniMalfunctionType.momtTypeName,MoniRecord.moreTestStep,MoniRecord.moreProblemDetail,MoniRecord.moreProblemReason,MoniRecord.moreSendTime,MoniRecord.moreSolvePerson,MoniRecord.moreProblemState,MoniRecord.moreSolveTime,MoniRecord.moreExtra,MoniRecord.moreCircle,MoniRecord.created,MoniRecord.createdBy,MoniRecord.lastUpd,MoniRecord.lastUpdBy,MoniRecord.moreUrl,MoniRecord.morePlace from MoniRecord MoniRecord, MoniProjectInfo MoniProjectInfo, MoniMalfunctionType MoniMalfunctionType, ProvinceInfo ProvinceInfo, SysUser MoniUser2  where MoniRecord.moreProjectName=MoniProjectInfo.mopiId and MoniRecord.moreMalfunctionType=MoniMalfunctionType.momtTypeId and ProvinceInfo.prinId=MoniRecord.moreAreaPro and MoniUser2.syusLoginName=MoniRecord.moreSendPerson and MoniUser2.syusLoginName=MoniRecord.moreInPerson order by MoniRecord.moreNo desc limit 0,10;
  
   各位前幫幫忙看一下是什么問題?是不是mysql版本的問題還是?

rardge

暈～～～
我都沒看，直接建議你先改用臨時表來試試看，逐步求解，不要把語句搞的太復雜了。

lrq3

呵呵,解決了,是mysql版本太低,升級到高版本就沒有問題