Administrator Rows vs actual number of records
am 27.04.2006 23:28:39 von vadimHi!
I imported some table (about 1500 records) using "LOAD DATA LOCAL
INFILE..." (command line console). No warnings, no skipped, no deletes
- all the recored are written to be imported.
However, in MySQL Administrator UI tool I see completely different
number in the "Rows" column. Making a SELECT query shows that the
actual number of records in the table is the correct one (the same
number as in text file table). Command line SHOW TABLE STATUS FROM ...
doesn't show any of these numbers.
I would expect that the "Rows" column doesn't show the actual number of
recored. But, the information about of 100 enteries table is shown
correctly (rows=records=100).
What is going on here ?
Thanks for help.
Vadim