The number of rows in the table is constantly changing every time I choose, can someone shed some light?

Question

I imported a bunch of data and the expected number of rows should have been 41856 .

Now every time I go to a table using phpMyAdmin , I see a different number of rows. Nothing connects to it, which will change the number of lines.

Here I added a few screenshots from the table, for a few seconds from each other.

41,610 entries, 41,759 entries, 41,647 entries ...

Answer 1

Some storage engines, such as MyISAM and ISAM, store the exact number. BUT for other storage systems, such as InnoDB, this value is approximate and may vary from the actual value by as much as 40-50%. In such cases, use SELECT COUNT (*) to get an accurate score.