title: Importing space-delimited data into MySQL
body: <p>I have file in the following format:</p>
  
  <pre><code>`e00` `e01` `e02` `e03`
  `e10` `e11` `e12` `e13
  </code></pre>
  
  <p>Trying to import the data with</p>
  
  <pre><code>LOAD DATA INFILE 'file' INTO TABLE 'foo' FIELDS TERMINATED BY ' ' ENCLOSED BY '`'
  </code></pre>
  
  <p>only seems to get the first 3 fields of each line. Is there a way to load the data without altering the file format?</p>