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

Query window shows 1-5000

forums › forums › SQLyog › Using SQLyog › Query window shows 1-5000

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • August 12, 2003 at 12:30 pm #14771
      Shadow
      Member

      Wrong. It shows the first 5000 records INCLUDING the first one. The reason for the limit clause is not to query a table fully that has millions of rows, but 5000 is still a fairly large number. If you want to use a different limit clause, then adjust the limit clause to fit your needs – there is no way to change this parameter of the default query.

    • August 12, 2003 at 6:14 pm #14772
      Ritesh
      Member

      You can permanently change the limits by modifying the LOWLIMIT and HIGHLIMIT values of sqlyog.ini that is located in the SQLyog directory.

      Be careful, as SQLyog stores all its information in the file!!

      HTH

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.