MySQL gives fluctuating row count when I query schema?

by

Assuming you are using InnoDB, as that is the default in 5.5.x according to the MySQL INFORMATION_SCHEMA TABLES documentation.

And this note:

The TABLE_ROWS column is NULL if the table is in the
INFORMATION_SCHEMA database.

For InnoDB tables, the row count is only a rough estimate used in SQL
optimization. (This is also true if the InnoDB table is partitioned.)

More Related Contents:

  1. If two columns are 1 then make new column
  2. Can we use CONCAT and JOIN together in MySQL? [closed]
  3. How to store Emoji Character in MySQL Database
  4. Any way to select without causing locking in MySQL?
  5. Log all queries in mysql
  6. Truncate all tables in a MySQL database in one command?
  7. Retrieving the last record in each group – MySQL
  8. Cast from VARCHAR to INT – MySQL
  9. Find distance between two points using latitude and longitude in mysql
  10. How to convert result table to JSON array in MySQL
  11. CROSS/OUTER APPLY in MySQL
  12. Solution to “subquery returns more than 1 row” error
  13. Adding multiple columns AFTER a specific column in MySQL
  14. Storing SHA1 hash values in MySQL
  15. Downloading MySQL dump from command line
  16. DOUBLE vs DECIMAL in MySQL
  17. Can a MySQL trigger simulate a CHECK constraint? [duplicate]
  18. MYSQL_ROOT_PASSWORD is set but getting “Access denied for user ‘root’@’localhost’ (using password: YES)” in docker container
  19. Terminating idle mysql connections
  20. int(11) vs. int(anything else)
  21. MySQL – How to select data by string length
  22. ColdFusion Parameterizing a Query
  23. How to select the first row for each group in MySQL?
  24. What to do when you need integers larger than 20 digits on mysql?
  25. How to update JSON data type column in MySQL 5.7.10?
  26. How to import large sql file in phpmyadmin
  27. How to figure out size of Indexes in MySQL
  28. Equivalent of MSSQL IDENTITY Column in MySQL
  29. #1060 – Duplicate column name ‘id’
  30. Failed to connect to mysql at 127.0.0.1:3306 with user root access denied for user ‘root’@’localhost'(using password:YES)

Leave a Comment