I have to correct my previos mail: using load data infile, all rows are
correctly loaded into the table. Yet, the control center displays a
smaller number of total records than the true number, which is
correctly displayed by count(*). What does the display in the control
center mean?
Wolfgang
Wolfgang -
> I have a text file with 120'000 lines. When I do a
> load data local infile
> only 85'416 records are loaded. There is no message of the sort
> Query OK, X rows affected
> just the next prompt is displayed.
>
> I'll be glad for any hint what could cause this behavior.
Hi,
I have a text file with 120'000 lines. When I do a
load data local infile
only 85'416 records are loaded. There is no message of the sort
Query OK, X rows affected
just the next prompt is displayed.
I'll be glad for any hint what could cause this behavior. I'm using
versi
