Menu
When I check my database, it's showing negative records for a table (e.g. -200,000), other tables' records are static.
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.
What could be happening?
554
MySQL ABS() function overviewIf n is a negative number, the ABS() function changes the negative value to positive value. In case n is zero or positive, ABS() function has no effect. The data type of the return value is the same as the data type of the input argument.
To counts all of the rows in a table, whether they contain NULL values or not, use COUNT(*). That form of the COUNT() function basically returns the number of rows in a result set returned by a SELECT statement.
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.
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.
175
as Eric Strom already mention that, it is correct which is that sign mean estimated total row by phpMyAdmin. you can always get a rid of that ~ sign or get exact value of its total row by clicking this number. here it is on my own table example :
and after click that number that started with ~ sign, you will get total row exactly after being re-calculated.
45
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
