phpMyAdmin 显示数据库表的负总记录
当我检查我的数据库时，它显示一个表的负记录(例如 -200,000)，其他表的记录是静态的.
When I check my database, it's showing negative records for a table (e.g. -200,000), other tables' records are static.
当我查看表格并返回摘要时，它会随机更改为 -198,000 或 -220,000...这不是静态的.
When I view the table and go back to the summary, it changes randomly to -198,000, or -220,000... It's just not static.
会发生什么?
推荐答案
这是一个老问题，但我遇到了这个问题，这篇文章是第一个出现在谷歌上的，所以我想我会提出正确的答案.
This is an old question but one that I ran into and this post was the first thing to show up on google so I thought I would put the right answer up.
您会注意到所有mysql 否定记录"问题都与大表或数据库有关.这不是负号它的〜，这意味着大约.基本上是说有那么多记录.据我所知，一旦任何表在 phpMyAdmin 中获得超过 20,000 条记录，它就会显示出来.这也是提问者人数不断波动的原因，这并不准确.
You'll notice that all of the "negative mysql records" questions are with large tables or databases. This isn't a negative sign its ~, which means approximately. It's basically saying that there's around that many records. As far as I can tell, it shows up once any table gets more than 20,000 records in it in phpMyAdmin. This is also why the askers numbers keep fluctuating, it's not exact.
相关文章