title: Import data in MySQL from a CSV file using LOAD DATA INFILE
body: <p>I am importing some data of 20,000 rows from a CSV file into MySQL.</p>
  <p>Columns in the CSV file are in a different order than MySQL tables' columns. How can I automatically assign columns corresponding to MySQL table columns?</p>
  <p>When I execute</p>
  <pre><code>LOAD DATA INFILE 'abc.csv' INTO TABLE abc
  </code></pre>
  <p>this query adds all data to the first column.</p>
  <p>What is the auto syntax for importing data to MySQL?</p>