| Lost connection to MySQL server during query [message #1198] |
Fri, 04 May 2007 09:23 |
 julian
Messages: 13
Registered: March 2007 |
Junior Member |
|
|
Hi Guys
If I execute this type of select command I get following error
select Distinct B.cdlabel, cdlabelText from cdlabel A ,entrycheck B, markingqc C where B.ImageId=C.ImageId and A.cdlabel = B.cdlabel and markingqc =2 and (B.BatchidName<>0 or B.BatchidLegal<>0) and ( KeyQc=0 )and ( Key1=6) and ( Key2=6) and counterN =1 and markflag = 0 AND IMAGEORDER =1 and utility <>1 order by cdlabelText
Error Code : 2013
Lost connection to MySQL server during query
(0 ms taken)
Even this error occurs while executing in Qury browser.
I created index also.
If the DB contains minimum records the result is displayed
If DB contains more number of records "Lost connection to MySQL server during query" error displayed.
Why this error occurs and what is the solution for it?
Thanks
|
|
|
Members
Search
Help
Register
Login
Home
