Export database and row count
| User, date | Message |
|---|---|
|
Written by kalvaro
2 years ago Category: Import/Export 440 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
2 years ago 3950 posts since Fri, 07 Apr 06 |
Agree. Both done in r3708 and r3709. |
|
Written by kalvaro
2 years ago 440 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. |