title: LOAD DATA INFILE with txt file
body: <p>i have txt file containing more than 50000 records.those 4 records (pid,#_pro_used,notused,selected) are separate with tab space.i want to insert these records to a table which having 5 columns (index,pid,#_pro_used,notused,selected)..Extra one (index) column should be the primary key containing count of the record.</p>
  
  <p>i have used this command..but its not working.</p>
  
  <pre><code>  LOAD DATA LOCAL INFILE 'D:/temp.txt' INTO TABLE temp_table    (COUNT(pid),pid,#_pro_used,notused,selected);
  </code></pre>
  
  <p>Is this possible? or i should go for a trigger?</p>