Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Problem Sorting a field

forums › forums › SQLyog › Using SQLyog › Problem Sorting a field

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 28, 2003 at 8:05 pm #7727
      fzwebyog
      Member

      Once i view a table using SQLYOG (Table ->insert and update data), I would like to be able to sort a

      column (field) ascendingly or descendingly. How do I do that? Thanks

    • February 28, 2003 at 8:20 pm #13830
      CalEvans
      Member

      The best way to do it is to use the order by clause in your select statement. However, if you don't want to make another trip to the database and you have a reasonable number of records (<500) you can click on the column heading to resort the result set. Click once for Descending, twice for ascending.

      HTH,

      =C=

    • March 1, 2003 at 4:23 am #13831
      Ritesh
      Member
      Quote:
      Once i view a table using SQLYOG (Table ->insert and update data), I would like to be able to sort a

      column (field) ascendingly or descendingly.

      As of now SQLyog does not supports sorting of data in Insert/Update Window…. In can only sort resultsets returned by a query in the Resultpane.

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.