Count records (in MySQL)

[slider2001]

MySQL.
I want to insert 1500 records but it's inserted only 1000 records. Why? I write "load data infile 'file.txt' into table t1" where file.txt consist of more than 1000 records. Why aren't others inserted? I hope somebody find a bit of time to answer me. Sorry for my English. Thanks.

[Mincer]

Table structure?

File structure?

[mitsubishi]

Was there any errors or did you suppress them? Without telling mySQL what to do if it comes across a duplicate on a unique key it will stop and complain.

[seanf]

Moved to a more appropriate forum

Sean

[slider2001]

I've understood all. Sorry for question. It was easy.