phpMyAdmin 显示数据库表的负总记录

phpMyAdmin showing negative total records for a database table(phpMyAdmin 显示数据库表的负总记录)
本文介绍了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.

这篇关于phpMyAdmin 显示数据库表的负总记录的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持编程学习网!

本站部分内容来源互联网,如果有图片或者内容侵犯您的权益请联系我们删除!

相关文档推荐

Hibernate reactive No Vert.x context active in aws rds(AWS RDS中的休眠反应性非Vert.x上下文处于活动状态)
Bulk insert with mysql2 and NodeJs throws 500(使用mysql2和NodeJS的大容量插入抛出500)
Flask + PyMySQL giving error no attribute #39;settimeout#39;(FlASK+PyMySQL给出错误,没有属性#39;setTimeout#39;)
auto_increment column for a group of rows?(一组行的AUTO_INCREMENT列?)
Sort by ID DESC(按ID代码排序)
SQL/MySQL: split a quantity value into multiple rows by date(SQL/MySQL:按日期将数量值拆分为多行)