Hi, all,

I was trying to load a local data file into a mysql table using DBI,
this is how I did

my $st = "load data local infile \'datafile.dat\' into talbe $table";
my $sth = $dbh->do($st);

it looks good, however, it was not.

in datafile.dat, there are 5053 rows, however there are only 4988 rows loaded
in the table, and the last row in the table was not loaded correctly, like

it should be
4567805  297  -13   54

but it actually was
456780  0  0  0

If I submit the SQL query in a client window manually, it works perfectly.
So, the data file should have no problem.

I Googled a while, just hit nothing, so anyone can gives an explanation for 
this?

Thanks.

Bill


      

Reply via email to