Default View Data Query

[bestbassbaits]

I think my default show data query changed some how.

When I right click on mouse in a table and click “show data”

This is the default query

select * from `bestbassbaits`.`webmod_documents_docs` limit 64, 65

How do I change this to show all data without having to manually run the query when I click on “show data”

Thanks

[Ritesh]

SQLyog will always show you the data with a limit clause (to accidently avoid huge SELECT stmts.). It takes these values from sqlyog.ini file.

There are two ways to change this value:

1.) Open up sqlyog.ini (found in the installation directory of SQLyog), and change the values for LowLimit and HighLimit value in SQLYOG section to whatever values you want. In your case it should be 0 for lowlimit and an arbitrarily high value for highlimit.

2.) Select the table, press F11. In the Insert/Update window there will be two limit boxes. Change the limit values and close the dialog. It will write down the modified value in the INI file.

HTH

[Author]

Posts