问题描述
当我检查数据库时,它显示某个表的否定记录(例如-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显示数据库表的总记录为负的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!