Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.

Tab "Data"

NicoDeluxe's profile image NicoDeluxe posted 7 years ago in General Permalink
Hello,

after many frustrating days, i have seen that the tab "data" in a table dont show ALL rows in a table, instead it guess and show some example rows.

I thought the data- tab shows all rows in the table, like a select * from table.

Is there a way to change the settings there? If i click on data tab i want to see exactly ALL rows

Thanks a lot
thadin's profile image thadin posted 7 years ago Permalink
You can view the executed queries in the query-log on the bottom of the screen.
By default there shouldn't be a filter active but pagination is turned on by default so you might not see everything depending on the size of your table.
ansgar's profile image ansgar posted 7 years ago Permalink
You can press the "Show all" button on the top right.

Additionally, you can modify the number of rows to load at once, in Tools > Preferences > Text formatting > "Number of rows displayed in data tab"
NicoDeluxe's profile image NicoDeluxe posted 7 years ago Permalink
AAAHHHH great, "Show all" was the hint!

Is there a way to make "Show all" as Default Setting?
ansgar's profile image ansgar posted 7 years ago Permalink
No. But you can set the "number of rows to display" to some millions.

Please login to leave a reply, or register at first.




Ads were blocked - no problem. But keep in mind that developing HeidiSQL, user support and hosting takes time and money. You may want to send a donation instead.