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

Order Desc When Clicking On A Table

forums › forums › SQLyog › SQLyog Comments › Order Desc When Clicking On A Table

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • December 10, 2009 at 10:18 am #11787
      jongliko
      Member

      Hi all,

      I have a little question. Is there a way to order desc a table when I open it. Each time I open a table I have to click two times on the first column to reorder desc my tables and see the last inserts…

      thanks for your help

    • December 10, 2009 at 3:06 pm #30129
      peterlaursen
      Participant

       no .. rows are printed in the order they are received from MySQL with a SELECT statements with no ORDER BY-clause. You will probably get different results depending on storage engine and/or indexes on the table. 

    • December 10, 2009 at 3:58 pm #30130
      peterlaursen
      Participant

      .. but why don't you simple write a SELECT .. WHERE .. ORDER BY  statement and save as a 'favorite'?

    • December 10, 2009 at 4:25 pm #30131
      jongliko
      Member

      Thanks for your answer. I have lots of tables, it will force me to write lots of select with the name of each tables. It's quicker for me to just click on the table name.

      In the preferences I have seen that I can select how many results I want in the default query. Maybe for a future version an option to specify the Order by… 😉

      Thanks again.

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