Heidi does not show all table`s rows, its size is 360 < 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)
Heidi does not show all table`s rows, its size is 360 < 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)
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.
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.
Please login to leave a reply, or register at first.