title: Can you define fields and values with a "LOAD DATA LOCAL INFILE" query in MySQL?
body: <p>I'm trying to import data into a MySQL table with values not defined in the input file.   I have this php string concatenated query:</p>
  
  <pre><code>"LOAD DATA LOCAL INFILE '".@mysql_escape_string($this-&gt;file_name).
  "' IGNORE INTO TABLE `".$this-&gt;table_name.
  "` FIELDS TERMINATED BY '".@mysql_escape_string($this-&gt;field_separate_char).
  "' OPTIONALLY ENCLOSED BY '".@mysql_escape_string($this-&gt;field_enclose_char).
  "' ESCAPED BY '".@mysql_escape_string($this-&gt;field_escape_char).
  "' LINES TERMINATED BY '". $this-&gt;line_separate_char .
  "' ".
  ($this-&gt;use_csv_header ? " IGNORE 1 LINES " : "")
  </code></pre>
  
  <p>Is there a way I can set the account id in this load statement?</p>