title: load data infile order by line
body: <p>I :) 
  I need to insert 13500 lines and +500 columns from csv.
  So, I use load data infile and it's work.</p>
  
  <p>But, I need exactly the same order in my MySQL database and my Csv.</p>
  
  <p>Actually, for example, the 1000 line of the csv can be at the 800 place in my base </p>
  
  <p>I need something like "Order by column1" but I don't find the clue.</p>
  
  <p>Thank for your help</p>
  
  <p>Ps : I have 2primary keys (ref of products) and the are not in the mathematical order (like 1, 8, 4, etc.)</p>
  
  <p>EDIT : My code</p>
  
  <pre><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
          ';
  </code></pre>
  
  <p>I just take the csv and use data local inline with him... And the order is'nt perfectly respected, I don't know why...</p>
  
  <p>My design Table </p>
  
  <pre><code>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;
  </code></pre>