distal-attribute
distal-attribute
distal-attribute
distal-attribute

Export database and row count

User, date Message
Written by kalvaro
3 years ago
Category: Import/Export
564 posts since Thu, 29 Nov 07
I have an InnoDB table where the system reports 1531 rows instead of the actual figure, 1327. So far so good: we all know that SHOW TABLE STATUS returns an approximation, not the real number.

The funny thing is that I used Heidi's "Export database as SQL" feature and the report grid displayed 1531 / 100%.

(BTW, it'd also be nice that stored routines would not display a -1 row count.)

Given that's a report of a very specific operation, wouldn't it make more sense to give the exact number? I suppose it could be obtained from the either the SELECT * metadata or an internal counter.
Written by ansgar
3 years ago
4800 posts since Fri, 07 Apr 06
Agree. Both done in r3708 and r3709.
Written by kalvaro
3 years ago
564 posts since Thu, 29 Nov 07
Lovely, thanks. Sometimes these little things make a big difference :)
 

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