Heidi does not show all table`s rows, < 1000

[expired user #10340]'s profile image [expired user #10340] posted 7 years ago in General Permalink

Heidi does not show all table`s rows, its size is 360 &lt; 1000, even when I execute a query over table, the result is empty. But the applications can read all rows.

My version is 9.4.0.5125 (64Bit)

kalvaro's profile image kalvaro posted 7 years ago Permalink

You can increase the size to your liking:

kalvaro's profile image kalvaro posted 7 years ago Permalink

Sorry... Did you mean a Query tab? If I run SELECT * FROM very_large_table I can see the complete result-set for a 260,000 row table :-?

[expired user #10340]'s profile image [expired user #10340] posted 7 years ago Permalink

Sorry, i guessed my msg was vague. The problem is: I have a table with 360 rows, but i can not see all rows, throught The DATA TAB, i only can see 334 rows. If i do a select, i obtain the same 334 rows. However, the applications and other workmates can see all data.

kalvaro's profile image kalvaro posted 7 years ago Permalink

The most likely reason is that you're connecting to a different server or database. It happens more often that you'd think.

Two obvious things to try to ensure that HeidiSQL is not messing with the results:

SELECT COUNT(*) FROM your_table

... and Tools-> Launch command line to open mysql command line with the same credentials.

kalvaro's profile image kalvaro posted 7 years ago Permalink

(Because you don't have an active filter, do you?)

[expired user #10340]'s profile image [expired user #10340] posted 7 years ago Permalink

Thanks a lot, and sorry, you are right, the server's address was changed

[expired user #10366]'s profile image [expired user #10366] posted 7 years ago Permalink

thank u, my friend spent days on it

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