0

When I do:

select count(1) from tbl_name;

it shows 299999 rows (that's also what I see when I scroll to the last row), but inside phpmyadmin it shows 309675 total rows).

What could be causing this?

Table is

ENGINE=InnoDB DEFAULT CHARSET=utf8

enter image description here

The table was populated with 299999 queries like below

INSERT INTO keyword_traffic1 (ID, keyword) VALUES ("", "'.$string.'");
Robert Sinclair
  • 4,550
  • 2
  • 44
  • 46

0 Answers0