I have a database which should contain 159,483 rows. If I execute a SELECT COUNT( * ) FROM invw2wfinal it reports 159,483 but if I view the table summary on phpyMyAdmin it shows various numbers ranging from 164,000 to 195,384.
Is this a bug or does anyone have any idea what is going on?
From phpmyadmin FAQ:
"phpMyAdmin uses a quick method to get the row count, and this method only returns an approximate count in the case of InnoDB tables. See $cfg['MaxExactCount'] for a way to modify those results, but this could have a serious impact on performance."
Thanks - I searched on Google but forgot to check their FAQ!
I've also had issues where phpMyAdmin simply won't run valid queries that run fine from my php code. phpMyAdmin is great but not perfect.