Query window shows 1-5000

[murugan]

Hello:

In the query window the default query is something like “select * from `images`.`image` limit 1,5000;”. This in effect shows all records except the first record, right? How can I change the limit to 0,5000 or any other value permanently?

Thanks……M

[Shadow]

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.

[Ritesh]

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