aspose file tools*
The moose likes JDBC and the fly likes Order by clause is not working in mysql 5 however same working in mysql 4 Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Order by clause is not working in mysql 5 however same working in mysql 4" Watch "Order by clause is not working in mysql 5 however same working in mysql 4" New topic
Author

Order by clause is not working in mysql 5 however same working in mysql 4

lokesh pattajoshi
Ranch Hand

Joined: Jul 29, 2009
Posts: 130
hi everbody i was using following code for sorting in mysql 4 it was working fine but it is not working in mysql 5 can any body please help me.

SELECT data "data value" FROM TABLE_NAME order BY "data value"


Regards,
Lokesh Kumar Pattajoshi
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

What is "data value"? Is is a literal, or the contents of a field?


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
lokesh pattajoshi
Ranch Hand

Joined: Jul 29, 2009
Posts: 130
hi thanks for your replay data value is alias name.
Campbell Ritchie
Sheriff

Joined: Oct 13, 2005
Posts: 38334
    
  23
Are you sure you haven't missed out an AS?
lokesh pattajoshi
Ranch Hand

Joined: Jul 29, 2009
Posts: 130
hi Campbell what is AS? now i got the problem if i am using alias name with white space(example "First Name")then it is not working but how to resolve it i don't know can you please help??
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: Order by clause is not working in mysql 5 however same working in mysql 4