Search...
FAQs Subscribe
Pie
FAQs
Recent topics Flagged topics Hot topics Best topics
Search...
Search within JDBC and Relational Databases Search Coderanch
Advance search Google search
Register / Login
advertise on coderanch book review grid granny polymorphism thread boost
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
building better world book book review grid advertise on coderanch thread boost meaningless drivel
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Paul Clapham
  • Ron McLeod
  • Jeanne Boyarsky
  • Tim Cooke
Sheriffs:
  • Liutauras Vilda
  • paul wheaton
  • Henry Wong
Saloon Keepers:
  • Tim Moores
  • Tim Holloway
  • Stephan van Hulst
  • Carey Brown
  • Frits Walraven
Bartenders:
  • Piet Souris
  • Himai Minh

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

 
lokesh pattajoshi
Ranch Hand
Posts: 130
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • 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...
Hibernate Eclipse IDE Java
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • 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 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
hi thanks for your replay data value is alias name.
 
Campbell Ritchie
Marshal
Posts: 75629
354
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • Quote
  • Report post to moderator
Are you sure you haven't missed out an AS?
 
lokesh pattajoshi
Ranch Hand
Posts: 130
posted 12 years ago
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
    Send
  • 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??
 
And tomorrow is the circus! We can go to the circus! I love the circus! We can take this tiny ad:
free, earth-friendly heat - a kickstarter for putting coin in your pocket while saving the earth
https://coderanch.com/t/751654/free-earth-friendly-heat-kickstarter
reply
reply
    Bookmark Topic Watch Topic
  • New Topic
Boost this thread!
Similar Threads
More...