Windows MYSQL Server crash when sending query

[BigBadDave]

Hi,
The sever crashes when sending the following query :

SELECT * FROM discoexams WHERE CLASS = 'Under 9' ORDER BY NAME ASC LIMIT 0, 10

its the : '

LIMIT 0, 10

' part that crashes the server

any thoughts welcome Regards

Big Bad Dave

davidbyng@hotmail.com

 

[scrivener227]

BigBadDave, I can't say that I know why it's crashing ( maybe the space between the limit args?), but I know that saying "LIMIT 0,10" is the same as "LIMIT 10"

Why not give that a try and see what happens.

Good luck.

--Jeff

 

[BigBadDave]

No that won't make any difference, even if I say LIMIT 10, 20 it still crashes the server

any other ideas?? Regards

Big Bad Dave

davidbyng@hotmail.com

 

[gerrygerry]

other queries are working, right?

have you tried putting the "limit" before the "order by"?

just a guess... i haven't ever dealt with this before.

good luck! -gerrygerry
Go To

http://quickfreewebsite.com!

 

[BigBadDave]

Its ok now I have figured it out, it was a corrupt version of MYSQL I installed the latest and its fine Regards

Big Bad Dave

davidbyng@hotmail.com