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.

可能会发生什么?

推荐答案

这是一个老问题，但是我遇到了一个问题，这篇文章是在Google上显示的第一件事，所以我认为我会提出正确的答案

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屋！