show table like 和count(*) 行数不一致

The number of rows. Some storage engines, such as MyISAM, store the exact count. For other storage engines, such as InnoDB, this value is an approximation, and may vary from the actual value by as much as 40 to 50%. In such cases, use SELECT COUNT(*) to obtain an accurate count.

行数。某些存储引擎，如MyISAM存储的确切数目。其他的存储引擎，如InnoDB，这个值是一个近似值，并可能会有所不同从实际价值高达40到50%。在这种情况下，使用select count（*）来获得准确的计数。