I Need A Short Tutorial On Sqlyog Showing All Table Rows

[peterlaursen]

What program version are you using?  

The setting to expose all rows should be persistent across sessions with recent versions.  If not you don't have write access to the folder where the setting is stored  or some software prevents you to write there.

[sqldave]

Thanks for your reply. I am using 8.7RC.

I have all the control settings AFAIK. The MySQL setup is on my desktop computer and I am the administrator…

Let me give you an example of the behavior I am referring to: In preferences, “Enable autopaging” is checked. “Remember setting for each query” is checked. My setting is “999999” rows.

OK. I go to the object pane, and click open a table. When the table opens, “Limit rows” is checked and the number of rows is set to 100. The table has about 7000 rows.

Why are not all 7000 rows shown?

My goal is to see ALL rows from ANY table ANY time I view the table in Sqlyog.

Thanks.

[ashwin]

Quote:

What is the rule on how Sqlyog shows table rows by the GUI alone (not using SELECT statements)?

The rule is that- For the first time when table is exposed the limit rows will be checked and the limit value is 0-100. Since then it will keep the persistence what user is setting himself.

Please tell, Whether this issue is reproducible to you?

[sqldave]

Thank you for your response.

So, I made sure that, for all 25 tables in my db, the LIMIT was UNCHECKED.

I repeatedly checked all tables to see if they kept the setting. YES, they did.

I then exited Sqlyog, and restarted it. Did each table in the db keep the setting? YES, they did.

I can now certify that this feature, unlike myself, works as intended!

Thanks, I'm now an expert on the LIMT ROWS checkbox! 😎

[Author]

Posts