Menu
I am running a request on a table of records with phpmyadmin, and the results count varies. For example, when showing the results it says "Showing records 1 - (~180,234 )".
This number changes each time I refresh, and no data is being added or removed.
When I do a SQL request for the record, the result stays the same. Is this an issue with phpMyAdmin?
839
MySQL COUNT() Function The COUNT() function returns the number of records returned by a select query.
COUNT(*) returns the number of rows in a specified table, and it preserves duplicate rows. It counts each row separately. This includes rows that contain null values.
mysql> SELECT COUNT(*) AS NUMBEROFCOLUMNS FROM INFORMATION_SCHEMA. COLUMNS -> WHERE table_schema = 'business' AND table_name = 'NumberOfColumns'; The output displays the number of columns.
For InnoDB tables, from phpMyAdmin's 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.
http://docs.phpmyadmin.net/en/latest/config.html?highlight=maxexactcount#cfg_MaxExactCount
155
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
