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.