walrus55 - 2008-02-25

Hello,

I am using MySQLdb with the following MySQL request: load data local infile 'toto.txt' into table toto fields escaped by '';
However, the file "toto.txt" contains 947 rows and only 935 are loaded.

When I load the file interactively within MySQL, all the 947 lines are loaded and I can see that 6 lines are duplicated: 935 + 6*2 = 947

Is there any way to prevent this ? or at least, to have one copy of the duplicated rows (that is a total of 941 rows) ?

Thanks in advance !