Win a copy of Java 9 Revealed this week in the Features new in Java 9 forum!
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Java JSRs Mobile Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Sheriffs:
Saloon Keepers:
Bartenders:

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

 
lokesh pattajoshi
Ranch Hand
Posts: 130
posted 7 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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
Posts: 10336
I like...
Eclipse IDE Hibernate Java
posted 7 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
What is "data value"? Is is a literal, or the contents of a field?

JavaRanch FAQ HowToAskQuestionsOnJavaRanch

 
lokesh pattajoshi
Ranch Hand
Posts: 130
posted 7 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
hi thanks for your replay data value is alias name.
 
Campbell Ritchie
Sheriff
Posts: 54033
130
posted 7 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Are you sure you haven't missed out an AS?
 
lokesh pattajoshi
Ranch Hand
Posts: 130
posted 7 years ago
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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??
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!

Similar Threads