load data infile order by line

Question

I :) I need to insert 13500 lines and +500 columns from csv. So, I use load data infile and it's work.

But, I need exactly the same order in my MySQL database and my Csv.

Actually, for example, the 1000 line of the csv can be at the 800 place in my base

I need something like "Order by column1" but I don't find the clue.

Thank for your help

Ps : I have 2primary keys (ref of products) and the are not in the mathematical order (like 1, 8, 4, etc.)

EDIT : My code

$dataload = 'LOAD DATA LOCAL INFILE "'.__FILE__.'../../../../bo/csv/'.$nomfichier.'"
            REPLACE
            INTO TABLE gc_csv CHARACTER SET "latin1"
            FIELDS TERMINATED BY "\t"
            IGNORE 1 LINES
        ';

I just take the csv and use data local inline with him... And the order is'nt perfectly respected, I don't know why...

My design Table

CREATE TABLE `csv` (
  `example` int(20) unsigned NOT NULL,
  `example` int(15) unsigned NOT NULL,
  `example` varchar(10) default NULL,
[...]
  `example` varchar(4) default NULL,
  PRIMARY KEY  (`RefCatSYS`,`IdProduit`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

Answer 1

I have solve the problem. In fact, the WS send to me a csv with a multiple couple of the two primary key. At the line 2365 and 9798, the RefCatSYS and IdProduit as the same. So the load data infile REPLACE the line 2365 by the 9798 and that change the order.

I ask them to send a 3th and UNIQUE primary key

Thank for your help, and sorry for the disruption.