title: add fixed value to column in Mysql where loading data from csv file
body: <p>I need to enter a text value that to represent the year (will be the same for every row) in a set of data being imported from a csv file. I am getting a syntax error each time. How do I specify the text value so that it will populate the column properly?</p>
  
  <pre><code>Load data local infile 'C:/Users/Candace.....csv'
  into table estimate(State, '2010', Population)
  fields terminated by ',';
  </code></pre>