phpMyAdmin 显示数据库表的负总记录 [英] phpMyAdmin showing negative total records for a database table

问题描述

当我检查我的数据库时，它显示一个表的负记录(例如 -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.

这篇关于phpMyAdmin 显示数据库表的负总记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！